I have 2 tables, one is master table and another person table. In master table one of the field is autogenerated.
I have a SP which has 2 insert statements to insert into both the tables in that case How can I get the autogenerated ID from the first table to insert into the 2nd table ie) masterid to the person master id field in person table. As the insert
is at the same time to both the tables. A single sp will do the insert.
View Complete Post