Create trigger trigger_name
on TB_SGJH for update
as
begin
update TB_SGJH set OpNum = OpNum+1,OpDate=getdate() where JH_ID = (select JH_ID from inserted)
end
转载于:https://www.cnblogs.com/mingjing/p/5752974.html
Create trigger trigger_name
on TB_SGJH for update
as
begin
update TB_SGJH set OpNum = OpNum+1,OpDate=getdate() where JH_ID = (select JH_ID from inserted)
end
转载于:https://www.cnblogs.com/mingjing/p/5752974.html