>Hello Borislav!
>In help Transact-SQL :
>
>@@IDENTITY, SCOPE_IDENTITY, and IDENT_CURRENT are similar functions because they all return the last value inserted into the IDENTITY column of a table.
>I have chosen first.
>Now I try to use SCOPE_IDENTITY() function.
>
>Thank you for answer.
>
Read the paragraph bellow that you quoted:
@@IDENTITY and SCOPE_IDENTITY return the last identity value generated in any table in the current session. However, SCOPE_IDENTITY
returns the value only within the current scope; @@IDENTITY
is not limited to a specific scope.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.