create table emp1
(
name varchar(20)
)
go
create table emp2
(
id int identity(1,1),
name varchar(20)
)
go
create trigger instrg_emp1
on emp1
after insert
as
begin
insert into emp2(name)
select name from inserted
select @@identity
end
go
insert emp1 values('denzil')
go