Home Forums SQL Server 2008 T-SQL (SS2K8) How to insert multiple rows into a table with identity column RE: How to insert multiple rows into a table with identity column
gvreddy04
Valued Member
Points: 65
More actions
September 3, 2013 at 3:50 am
#1646943
Solution:
1) Set IDENTITY_INSERT to ON.
2) Insert customers data into Customer table.
3) Set IDENTITY_INSERT to OFF.
Read full article here.