How To Insert Data Into An Identity Column



TODO:

Have you ever wanted to insert data into a table, and specify an identity column.

 

SOULTION:

 

SET IDENTITY_INSERT MyTable ON

--do my inserts

SET IDENTITY_INSERT MyTable OFF

 

 

NOTES:

There are no notes on this topic.