随手敲的,可能手误。 CREATE TRIGGER t ON A_1 FOR UPDATE AS BEGIN IF UPDATE(A_1) BEGIN UPDATE B SET c=NULL FROM B INNER JOIN DELETED a ON a.A_1=b.B_1 UPDATE B SET c='已用' FROM B INNER JOIN INSERTED a ON a.A_1=b.B_1 ENDEND
CREATE trigger ATrigger on A for update as update t2 set c='' from deleted t1,B t2 where t1.A_1 =t2.B_1 update t2 set c='已用' from inserted t1,B t2 where t1.A_1=B_1
CREATE TRIGGER t
ON A_1
FOR UPDATE
AS
BEGIN
IF UPDATE(A_1)
BEGIN
UPDATE B SET c=NULL FROM B
INNER JOIN DELETED a
ON a.A_1=b.B_1
UPDATE B SET c='已用' FROM B
INNER JOIN INSERTED a
ON a.A_1=b.B_1
ENDEND
for update
as update t2
set c=''
from deleted t1,B t2
where t1.A_1 =t2.B_1 update t2
set c='已用'
from inserted t1,B t2
where t1.A_1=B_1