archana_a
June 19th, 2002, 12:44 AM
Via html page the user enters data. using asp and ado I insert this data into a table. Once the new rows have been inserted i need to generate a unique id and insert this id and the new set of corresponding rows into another table.
I plan to write a stored procedure to insert the new rows and id into the other table. I am not sure if this is the right way. Also I dont know how to write the procedure.
I plan to write a stored procedure to insert the new rows and id into the other table. I am not sure if this is the right way. Also I dont know how to write the procedure.