Wednesday, March 21, 2012

How to enable and disable the identity

Hello there :-)
Kindly help me find the answer on how to enable and disable the identity of a field on a table via SQL Script?
Thanks :-)SET IDENTITY_INSERT
Allows explicit values to be inserted into the identity column of a table.

Syntax:
SET IDENTITY_INSERT [ database. [ owner. ] ] { table } { ON | OFF }sql

No comments:

Post a Comment