Tuesday, March 20, 2012

current keyID from sql update

When I return from executing a sql storedprocedure where I insert a record, where can I find the keyID?Inside of the stored procedure you should set up an OUTPUT parameter called e.g. @.keyID to communicate the newly added ID back to your page. After the INSERT you would do this to capture the newly added ID:

SELECT @.keyID = Scope_Identity()

Terri|||Got it! Thanks

No comments:

Post a Comment