单据修改时，审核日期更新为当前日期（触发器）

ALTER TRIGGER [dbo].[t_BOS257800028_Update] ON [dbo].[t_BOS257800028]
after Update
as
SET NOCOUNT ON;

begin
update t set t.fcheckdate=CONVERT(datetime,GETDATE(),23)-CONVERT(time,GETDATE(),23) from t_BOS257800028 t
inner join Inserted v on t.fid=v.fid
where t.FMultiCheckStatus<>16
end