March 7, 2011

How to insert identity key value in SQL Server

Before Inserting Identity key values we need to off IDENTITY_INSERT property

SET IDENTITY_INSERT dbo.Login_Master OFF

Now we can Insert values
SET IDENTITY_INSERT dbo.Login_Master ON

No comments:

Post a Comment