I have to create procedure to insert or update tables which have relationship, for example
tableA (aID is primary key)
aID value1 value2
1 1000 2000
tableB (bID is primary key)
bID aID values3 value4
101 1 fjdksal 20
now I have an application want to call a procedure to insert new values or update the data,
--in the procedure, what is the easy way to insert or update these parent-child tables?
using scope_identity() , it gives error message
--no triger in the database , so have to pass the aID into the procedure ,right?