sql server - How to insert rows in another table based on insert in first table -

sql server - How to insert rows in another table based on insert in first table -

if insert happens in table then,i need insert lastly inserted row table b.

how can using @@rowcount.

i trying below code.

create table table1 ( id int identity(1,1), column1 nvarchar ) create table table2 ( id int identity(1,1), column1 nvarchar ) create procedure insert1 @column1 nvarchar declare @t int,@column2 nvarchar insert table1 values(@column1) select * table1 set @t= (select @@identity table1) insert table2 values (@t)

please allow me know how can same trigger.

you write trigger this:

create trigger trgtableainsert on dbo.table1 insert insert dbo.table2(column1) select column1 inserted

points note:

a trigger called once per statement, e.g. if insert statement inserts 10 rows, trigger called once , inserted contains 10 newly inserted rows (do want insert 10 of tableb?)

i recommend utilize schema prefix on tables (the dbo. part)

i recommend always explicitly specify list of columns, both on insert select statement - don't omit those! (or might run messy , hard-to-debug issues when 1 of tables changes)

sql-server sql-server-2008