View Single Post
  #1 (permalink)  
Old June 8th, 2003, 07:17 PM
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 Creating a stored procedure

I am still a newbie and would like to ask a question concerning a a stored proc that I am not sure about.
The goal is to pass the indentity pk to a stored procedure.I then want to select that particular record,insert a new record in that same table with values from the record I selected.Then pass back to asp coding , the new record identity of the newly inserted record. If this is possible, would some be as so kind to point me in the right directions on how to acheive this feat ?? I have written stored procedures but not like this.Ths stored proc would be used by many different users so i want to careful about any multi-user problems that could occurr.
And thank you in advance...
Reply With Quote