Home Forums Article Discussions Article Discussions by Author Discuss content posted by Susantha Bathige Identity Columns RE: Identity Columns
Dariusz Czechowicz-474456
SSC Enthusiast
Points: 128
More actions
July 7, 2008 at 8:29 am
#838936
Here is an alternative solution without 'set identity_insert' 😉
INSERT INTO TEST WITH (KEEPIDENTITY) (Col1)
SELECT IDENT_CURRENT('Test') FROM OPENROWSET(BULK N'C:\boot.ini', SINGLE_BLOB) AS a