触发器 同一表，修改某一字段，同时修改另一个字段

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