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