在建立trigger时,是否可以进行如下操作。CREATE TRIGER tr_aa_update on card
AFTER UPDATE
AS
UPDATE Card_his SET (cardType,PersonName)=(SELECT cardtype,name FROM INSERTED) /*这个地方报错*/
GO
AFTER UPDATE
AS
UPDATE Card_his SET (cardType,PersonName)=(SELECT cardtype,name FROM INSERTED) /*这个地方报错*/
GO
AFTER UPDATE
AS
UPDATE Card_his
SET cardType = i.cardtype
PersonName = i.name
from Card_his c , INSERTED i
where c.关键字 = i.关键字
GO
AFTER UPDATE
AS
UPDATE Card_his SET cardType=i.cardtype,PersonName=i.name from inserted i /*这个地方报错*/
GO
AFTER UPDATE
AS
UPDATE Card_his SET cardType=i.cardtype,PersonName=i.name from inserted i join Card_his c on i=关联字段=c.关联字段 /*这个地方报错*/
GO
AFTER UPDATE
AS
UPDATE Card_his SET cardType=i.cardtype,PersonName=i.name from inserted i