create trigger t1 on table1 for update
as
update table2 set colname = inserted.colname from inserted where table2.id = inserted.id
go
愉快的登山者 ⊙
◢◣◢◣◢◣
as
update table2 set colname = inserted.colname from inserted where table2.id = inserted.id
go
愉快的登山者 ⊙
◢◣◢◣◢◣
CREATE TRIGGER 名2 ON dbo.表1
FOR update
AS
update 表2 set 列=aa.列 from inserted aa where aa.编号=表2.编号
as
update table2 set colname = inserted.colname from inserted where table2.id = inserted.id
go
但我必须将TEXT类型的数据更新到表2中