关于触发器的问题我的触发器不起作用. [英] problem about the trigger my trigger is not working.

问题描述

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

我的触发器无法正常工作，因为它插入了单个表而不是两个表中.
pls快速响应我

My trigger is not working properly as it inserts in single table not in both table.
pls quick responce me

推荐答案

它仅插入第一个表中，因为您在第二个插入之前结束了触发器.

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

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

这篇关于关于触发器的问题我的触发器不起作用.的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！