ALTER trigger DBA.t2 on
DBA.labdetail for update
as
if update(val1)
begin
update labdetail set lised = 0
where deleted.val1 = labdetail.val1
end
当我update val1时就报错,求解决。
...全文
1614打赏收藏
表用了触发器后,使用update语句时报错,求解决方
ALTER trigger DBA.t2 on DBA.labdetail for update as if update(val1) begin update labdetail set lised = 0 where deleted.val1 = labdetail.val1 end 当我update val1时就报错,求解决。