>>We are looking at SCOPE_IDENTITY() to get the newly generated autoincrement. How does it work?
>
>It's my understanding that SCOPE_IDENTITY() was created for just this scenario (new with SQL Server 7, if I recall correctly). After inserting a new row into the parent table, execute:
>
>SELECT SCOPE_IDENTITY() as IDValue
>
>on the server, and this will return a recordset with a single record containing the Identity value just created by the insertion. The problem with the earlier @@Identity was that it returned the last identity value generated, not necessarily the one on the current connection, which is what you're after.
I think it was added in SQL Server 2000.
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only