Click here to Skip to main content
15,868,048 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
SQL
create trigger tr_em 

on emp  

for insert  

as
 
begin  
    declare @empname varchar(20)  
    declare @lastname varchar(30)  
    declare @address varchar(20)  
    declare @DOB datetime  
    declare @salary int
    
    select @empname=empname,@lastname=lastname,@address=address,@DOB=DOB,@salary=salary from inserted  
      
    insert into emp_insert values(@empname,@lastname,@address,@DOB,@salary)  
end

insert into emp values ('esdfs','sgssadsdgs','sgsadags','2jan 1878',5456555)

select * from emp_insert


My trigger is not working properly as it inserts in single table not in both table.
pls quick responce me
Posted
Updated 11-Nov-11 0:02am
v3
Comments
Reiss 11-Nov-11 6:03am    
[edit] formatted as code - removed urgency

1 solution

It inserts only into the first table, because you end te trigger before the second insert.

SQL
create trigger tr_em

on emp

for insert

as

begin
    declare @empname varchar(20)
    declare @lastname varchar(30)
    declare @address varchar(20)
    declare @DOB datetime
    declare @salary int

    select @empname=empname,@lastname=lastname,@address=address,@DOB=DOB,@salary=salary from inserted

    insert into emp_insert values(@empname,@lastname,@address,@DOB,@salary)
end

insert into emp values ('esdfs','sgssadsdgs','sgsadags','2jan 1878',5456555)

end

select * from emp_insert
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS


CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900