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?

  • 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.

    Not in SQL2000

    _____________
    Code for TallyGenerator