|
I have 2 tables. I need to insert row to a table so that i will get the identity column value using that identity column value i need to add a row in the second table.How to do it without using triggers? Table 1: userid identitycolumn primary key val1 varchar null val2 varchar null Table2 userid not null value3 null value4 null
(comments are locked)
|
INSERT Table1 (val1,val2)
OUTPUT Inserted.UserID,NULL,NULL INTO Table2
VALUES('1','2')
(comments are locked)
|
Your answer
