Question : identity insert on sql server
Answered by : illuzio
SET IDENTITY_INSERT sometableWithIdentity ON
INSERT sometableWithIdentity (IdentityColumn, col2, col3, ...)
VALUES (AnIdentityValue, col2value, col3value, ...)
SET IDENTITY_INSERT sometableWithIdentity OFF
Source : | Last Update : Wed, 25 Dec 19
Question : sql server insert get identity
Answered by : thomas-framery
INSERT INTO MyTable
OUTPUT INSERTED.ID
VALUES (...)
Source : https://stackoverflow.com/questions/42648/sql-server-best-way-to-get-identity-of-inserted-row | Last Update : Wed, 31 Aug 22