34,594
社区成员
发帖
与我相关
我的任务
分享
Create trigger TR_1 ON T_1
FOR UPDATE
AS
IF EXISTS(SELECT 1 FROM T_1 A,DELETED B WHERE A.id=B.id AND DATEDIFF(mi,A.CREATEDATE,GETDATE()) >=2)
AND UPDATE(F0020)
BEGIN
UPDATE A SET A.F0010='B'
FROM T_1 A,DELETED B
WHERE A.ID=B.ID
END