Wednesday, January 13, 2010

SET IDENTITY_INSERT setting

You cannot enter a value for an identity column when executing an INSERT or UPDATE statement. You can overcome this limitation by issuing The SET IDENTITY_INSERT ON command in the current connection.
Let's see this example:


Posted by at
Labels: ,

2 comments:

Unknown said...

What about Update

January 13, 2010 at 9:07 AM
Fadi Ahmad Abdulwahab said...

yes, it's same as insert statement

good luck..

January 13, 2010 at 3:48 PM

Post a Comment

Subscribe to: Post Comments (Atom)