create trigger my_tirgger on IGN1
for insert
as
update chek
set
Code=Itemcode,
name =ItemName
from inserted i,chek
where i.连接字段= chek.连接字段
for insert
as
update chek
set
Code=Itemcode,
name =ItemName
from inserted i,chek
where i.连接字段= chek.连接字段
AS
update chek set code = m.code + n.code , name = m.name + n.name from chek m , inserted n where m.Itemcode = n.Itemcode and m.ItemName = n.ItemName
GO
FOR INSERT
AS
INSERT check表(code,Name)SELECT code,Name FROM INSERTED
for insert
as
insert into @chek(Code,Name) select Itemcode,ItemName FROM INSERTED