25 December 2013

How to Reset the identity column in sql server

Because Identity on a column by default is Off. We can reset it as 

SET IDENTITY_INSERT 'TABLENAME' ON

And again off this as

SET IDENTITY_INSERT 'TABLENAME' OFF 

No comments:

Post a Comment