CREATE TRIGGER aa ON 你的表
FOR UPDATE
AS
IF UPDATE (A)
UPDATE 你的表
SET B = CASE A WHEN 1 THEN 1 ELSE 0 END
FOR UPDATE
AS
IF UPDATE (A)
UPDATE 你的表
SET B = CASE A WHEN 1 THEN 1 ELSE 0 END
调试欢乐多
For Update
As
Update yourTable set B = (case when A = 1 then 1 else 0 end)
-- from yourTable join inserted on yourTable.A = Inserted.A
FOR UPDATE
AS
IF UPDATE (A)
UPDATE 你的表 SET B = CASE A WHEN 1 THEN 1 ELSE 0 END FROM INSERTED
WHERE 你的表.ID=INSERTED.ID
FOR UPDATE
AS
IF UPDATE (A)
UPDATE TABLENAME SET B = CASE TABLENAME.A WHEN 1 THEN 1 ELSE 0 END FROM INSERTED
WHERE TABLENAME.ID=INSERTED.ID