SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
ALTER TRIGGER TR_TMP
ON TMP
FOR UPDATE
AS
UPDATE TMP SET LASTTIME=GETDATE() WHERE ID IN (SELECT ID FROM inserted)
GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
ALTER TRIGGER TR_TMP
ON TMP
FOR UPDATE
AS
UPDATE TMP SET LASTTIME=GETDATE() WHERE ID IN (SELECT ID FROM inserted)
GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO