sql query for inserts records in multiple tables

--Table creation A, B and C ; insert sample data into Table A
create table A ( ID INT PRIMARY KEY, name varchar(10))
INSERT A values(1, 'AAA'), (2, 'BBB'), (3, 'CCC')

create table B ( ID INT PRIMARY KEY, name varchar(10))
create table C ( ID INT )

-- Decalre Temparary table for holding newly inserted IDs of Table B
DECLARE @tempC TABLE (ID INT)
-- Insert values into table B from table A 
INSERT B(ID, name) 
OUTPUT INSERTED.ID INTO @tempC  -- here insert temp IDs into temporary table (@tempC)
SELECT ID, Name FROM A

-- Insert New IDs into Table C
INSERT C SELECT * FROM @tempC

--Verify Values
SELECT * FROM A
SELECT * FROM B
SELECT * FROM C

DROP TABLE A
DROP TABLE B
DROP TABLE C

Mark This Response as Answer
--
Chandu
http://www.dotnetfunda.com/images/dnfmvp.gif

Mark This Response as Answer
--
Chandu
http://www.dotnetfunda.com/images/dnfmvp.gif

INSERT INTO Test1(Name,Address)
OUTPUT INSERTED.Id,INSERTED.Name,INSERTED.Address Into Test2
VALUES ('Test3','Pune')

INSERT INTO Test3(Id,Name,Address)
Select * From Test2

select * from test1;
select * from test2;
select * from test3;

Rejesh Kumar