is there a way when making a stored procedure if i can enter the information in multiple tables?? say the primary key into another table to link the relationship? or should i just pull it out and then put in?
Yes it is possible.
After the first insert call "SCOPE_IDENTITY() " .
This will retrieve the ID number from the newly inserted row. This can be stored in a variable and entered into a second insert :)
No comments:
Post a Comment