Multiple Output Into in SQL Server

Asked Apr 19 '17 at 09:59

Active Apr 19 '17 at 11:58

Viewed 370 times

I have four tables: A,B,C,D. A has PK of B, B has PK of C and C has PK of D. I want to insert data to all of them. I have tried using Output Into by using two tables

declare @a table(
no int identity(1,2),
nama varchar(30)
)

declare @b table(
no int identity(1,1),
nama varchar(40)
)
insert into @b (name) values('test')
merge @a 
using @b 
on 0=1
when not matched
then insert (nama)
Values ('test2')
output inserted.no, inserted.nama into @b;

select * from  @b

How can I add more Output Into so I can insert PK of @b to another table?

edited Apr 19 '17 at 11:58

asked Apr 19 '17 at 09:59

patrixx

Possible duplicate of [How to insert multiple records and get the identity value?](http://stackoverflow.com/questions/95988/how-to-insert-multiple-records-and-get-the-identity-value) – Tanner Apr 19 '17 at 10:24
its not duplicate – patrixx Apr 20 '17 at 00:56
It might help others if you state why it isn't a duplicate. – Tanner Apr 20 '17 at 06:35

Multiple Output Into in SQL Server

0 Answers0