SQL Server

Create parameter less stored procedure in Sql Server database

This tutorial will show you how to create parameter less stored procedure to return data from Sql Server database? To create a […]

Updated on     Kisan Patel

Create Stored procedure that accepts parameters in SQL Server

This tutorial will show you how to create stored procedure that accepts parameters to fetch data from database? To create a […]

Updated on     Kisan Patel

How to create INSTEAD OF trigger in SQL Server?

This tutorial will show you how to create INSTEAD OF trigger in SQL Server? INSTEAD OF trigger executes in place […]

Updated on     Kisan Patel

Enable trigger in SQL Server

This tutorial will show you how to enable trigger in SQL Server? To enable trigger that was disabled, we use […]

Updated on     Kisan Patel

Disable trigger in SQL Server

This tutorial will show you how to disable a trigger in SQL Server? To disable a trigger, open the query […]

Updated on     Kisan Patel

Create AFTER UPDATE triggers in SQL Server

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

Updated on     Kisan Patel

Create AFTER INSERT triggers in SQL Server

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

Updated on     Kisan Patel

Using Cursor in SQL Server

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

Updated on     Kisan Patel

Set Multiple Columns of the Table as Primary key in SQL Server

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

Updated on     Kisan Patel

Add New Column in existing Database Table as Auto Increment column in the SQL Server?

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

Updated on     Kisan Patel