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