sql Identity Insert

SET IDENTITY_INSERT tablename ON
--now you can insert rows into a table, specifying the identity column's value
SET IDENTITY_INSERT tablename OFF
Use to insert rows into a table with an identity column.

Updated: Friday 8th October 2010, 22:52pm

There are 0 comments

Leave a comment of your own

Comments are currently closed.