View Single Post
  #5 (permalink)  
Old June 9th, 2003, 07:38 AM
marthaj marthaj is offline
Authorized User
 
Join Date: Jun 2003
Location: Mount Gilead, Ohio, USA.
Posts: 17
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Thank you for pointing that out about scope_identity.
That was something that I learned very early in writing sprocs that return the identity.
But I have another question. I think I know the bits and pieces of how do the following for the procedure, but am very uncertain.
My question is, how do I handle it when i wan to change some of the fields values as I am inserting them into the new row ??
I would think I would have to declare some variables to hold the parameter values that I pass for the new values, but uncertain as how to arrange the sproc then ??
Again, thank you for responding
Reply With Quote