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
SET IDENTITY_INSERT 'TABLENAME' ON
And again off this as
SET IDENTITY_INSERT 'TABLENAME' OFF
No comments:
Post a Comment