name參數在inserted/deleted這兩個虛擬表里面記錄著呀。UPDATE table1 SET nu=inserted.nu from table1 INNER JOIN inserted ON nu.name=inserted.name--需求是不是這樣?
name參數在inserted/deleted這兩個虛擬表里面記錄著呀。UPDATE table1 SET nu=inserted.nu from table1 INNER JOIN inserted ON nu.name=inserted.name--需求是不是這樣?
CREATE TRIGGER trg1 ON table FOR UPDATE AS if update(name) begin update .... ....select name from inserted)//inserted表放着修改之后的数据,"dd" from bgs.daanml ....select dabh from deleted)//deleted表放着修改之前的数据,如"ddd" end update类型的触发器产生两张表,一为inserted,一为deleted
FOR UPDATE
AS
if update(name)
begin
update ....
....select name from inserted)//inserted表放着修改之后的数据,"dd"
from bgs.daanml
....select dabh from deleted)//deleted表放着修改之前的数据,如"ddd"
end
update类型的触发器产生两张表,一为inserted,一为deleted
使用虚表