Home Forums SQL Server 2005 T-SQL (SS2K5) Inserting value for identity column in a temporary table RE: Inserting value for identity column in a temporary table
autoexcrement
SSCertifiable
Points: 5951
More actions
July 7, 2014 at 4:38 pm
#1727610
You can also insert explicit values into an IDENTITY column by using SET IDENTITY_INSERT
ON.
http://msdn.microsoft.com/en-us/library/ms188059.aspx