The Tech Pursuit
The Dev Shelf
Pages
Home
Interview Questions
About Me
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
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment