Home Forums SQL Server 7,2000 T-SQL Which one to use among Ident_Current,Scope_Identity and @@Identity? RE: Which one to use among Ident_Current,Scope_Identity and @@Identity?
Sergiy
SSC Guru
Points: 110206
More actions
September 29, 2008 at 3:56 pm
#878642
Chris Harshman (9/29/2008)If your INSERT statement can add multiple rows to the table, then you can use the OUTPUT clause of the INSERT statement to put the entire list into a table variable.
Chris Harshman (9/29/2008)
Not in SQL2000
_____________Code for TallyGenerator