In a web-based app. designed using Bluestone's Sapphire/Web (Yes, I know...) I enter a new row to a table with its key automatically inserted via the identity_insert option in SQL Server. Immediately after this row is inserted, I need to know what value was just inserted (I don't feel that just taking the largest value in the table is safe enough). Is there a way to return the value inserted when identity_insert is used?<br><br>Thanks in advance, <br>Brett
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
SQL Server 7 - Need the value of an identity just inserted
- Thread starter Brett123
- Start date
From Books On Line: <br><br><i>After an INSERT, SELECT INTO, or bulk copy statement completes, <b>@@IDENTITY</b> contains the last identity value generated by the statement. If the statement did not affect any tables with identity columns, @@IDENTITY returns NULL. If multiple rows are inserted, generating multiple identity values, @@IDENTITY returns the last identity value generated.</i><br><br>i.e. immediately after the insert if you <FONT FACE=monospace>SELECT @the_id = @@IDENTITY</font> you will get back the value. <p> <br><a href=mailto: > </a><br><a href= home</a><br>
- Status
Similar threads
- Locked
- Question
