inserted 更新后值的表,更新多少条记录,里面就有多少条记录CREATE TRIGGER [UPDATEProjectUser ] ON dbo.tb_ProjectUser
FOR UPDATE
AS
insert into tb_alert select * from inserted where lock=1
FOR UPDATE
AS
insert into tb_alert select * from inserted where lock=1
CREATE TRIGGER [UPDATEProjectUser ] ON dbo.tb_ProjectUser
FOR UPDATE
AS
insert into tb_alert select * from inserted where lock=1一不需要declare那么多变量的。