This example will show you how to create AFTER UPDATE triggers in SQL Server? CREATE TRIGGER UPDATETrigger ON [NORTHWND].[dbo].[Region] AFTER […]

This tutorial will show you how to create AFTER INSERT triggers in SQL Server? Here, AFTER INSERT trigger executes after […]

A cursor is a database object used retrieve data from a result set one row at a time or row-by-row […]

Yes, it is possible to create primary key on combination of columns on the table. To do that select columns […]

Adding a new column as auto increment to the existing database table is not possible through the SQL Server Management […]

To specify see value and increment value to the auto increment column in the existing database table, we pass parameter […]

To create a new column in the existing database table as primary key and auto increment, execute following script in […]

This tutorial will explain how to create a new database user for SQL Server database in SQL Server 2008, SQL […]

This tutorial will explain you how to take a backup of a database or create a backup file (.bak) of […]

This tutorial will explain you how to restore a database using SQL Server Management Studio. To restore a database in […]