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.



Add comment

  Country flag

biuquote
  • Comment
  • Preview
Loading