Thread: How to return a Pk value from one stored procedure to another storedprocedure
View Single Post

   
  #3 (permalink)  
Old 05-16-2008, 01:39 PM
Plamen Ratchev
 
Posts: n/a
Default Re: How to return a Pk value from one stored procedure to another stored procedure
In addition to use SCOPE_IDENTITY() on SQL Server 2005 you can use the
OUTPUT clause to return the inserted values.

HTH,

Plamen Ratchev
http://www.SQLStudio.com

Reply With Quote