create trigger my_trig on 入库表 for inserted as begin insert into 库存表 (字段1,2..n) select ... from inserted end
create trigger 触发器名 on 表名或视图名 instead of insert 当执行insert 时 会发生以下事件 as declare @id int 局部变量1 declare @name varchar(50) 局部变量2 declare @country varchar(50) 局部变量3 declare @cid int 局部变量4 select @局部变量1=id,@2=name, @3=country from inserted select @局部变量4=cid from Country where country = @局部变量3 insert into 表名 values(@局部变量1,@ 局部变量4)
as
begin
insert into 库存表 (字段1,2..n) select ... from inserted
end
on 表名或视图名
instead of insert 当执行insert 时 会发生以下事件
as
declare @id int 局部变量1
declare @name varchar(50) 局部变量2
declare @country varchar(50) 局部变量3
declare @cid int 局部变量4
select @局部变量1=id,@2=name, @3=country from inserted
select @局部变量4=cid from Country where country = @局部变量3 insert into 表名 values(@局部变量1,@ 局部变量4)