Viewing post 1 (of 1 total)
We use RETURN @@Identity as in the example below:
INSERT INTO tblUsers (FName, LName)
VALUES ('John', 'Smith')
RETURN @@Identity
GO
August 27, 2004 at 8:28 am
#520888