CREATE Trigger Update_TR On pub_档案
For Update
As
Begin
If Update(成绩)
Begin
Update B Set B. 理论考试成绩 = A.成绩 From Inserted A Inner Join 从业培训档案 B On A.xyid = B.id Where A.成绩> 80
end
end
For Update
As
Begin
If Update(成绩)
Begin
Update B Set B. 理论考试成绩 = A.成绩 From Inserted A Inner Join 从业培训档案 B On A.xyid = B.id Where A.成绩> 80
end
end
As
Begin
If Update(成绩)
Update B Set B. 理论考试成绩 = A.成绩
From Inserted A Inner Join 从业培训档案 B On A.xyid = B.id
Where A.成绩> 80
end
As
Begin
If Update(成绩)
Update B Set 理论考试成绩 = A.成绩
From Inserted A Inner Join 从业培训档案 B On A.xyid = B.id
Where A.成绩> 80
end
For Update
As
Begin
If Update(成绩)
Begin
Update 从业培训档案 Set 理论考试成绩=A.成绩 From inserted A,从业培训档案 B
Where A.成绩> 80 and A.xyid = B.id
end
end