22,302
社区成员




-- =============================================
CREATE TRIGGER updateProductAttributeValueByChineseName
on A
for update
as
if update(ChineseName)
begin
if(i.LanguageID=8)
update [a] set ChineseName=i.ChineseName
from a p,Deleted d,Inserted i
where p.ChineseName=d.ChineseName and p.avid=d.avid and p.LanguageID<>8
end
报错 无法绑定由多个部分组成的标识符 "i.LanguageID"。
因为无法执行 所以也不知道其他的条件写的是否正确
CREATE TRIGGER updateProductAttributeValueByChineseName
on A
for update
as
if update(ChineseName)
begin
if exists(select * from inserted i where i.LanguageID=8)
update [a] set ChineseName=i.ChineseName
from a p,Deleted d,Inserted i
where p.ChineseName=d.ChineseName and p.avid=d.avid and p.LanguageID<>8
end