找到标识ID列应该就可以CREATE TRIGGER TRIGGERNAME ON tbA for INSERT,UPDATE AS BEGIN update INSERTED set INSERTED.XXX=... from INSERTED,tbA where INSERTED.ID=tbA.ID END
appleller CREATE TRIGGER TRIGGERNAME ON tbA for INSERT,UPDATE AS BEGIN update INSERTED ----为什么更新的是IMSERTED,还不是原始表 set INSERTED.XXX=... from INSERTED,tbA where INSERTED.ID=tbA.ID END
IDENT_CURRENT有什么区别
for INSERT,UPDATE
AS
BEGIN
update INSERTED
set INSERTED.XXX=...
from INSERTED,tbA
where INSERTED.ID=tbA.ID
END
CREATE TRIGGER TRIGGERNAME ON tbA
for INSERT,UPDATE
AS
BEGIN
update INSERTED ----为什么更新的是IMSERTED,还不是原始表
set INSERTED.XXX=...
from INSERTED,tbA
where INSERTED.ID=tbA.ID
END