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, 01:29pm

There are 0 comments

snippets.slickhouse.com