—–触发器批量触发SQL脚本示例—–
CREATE TRIGGER tri_Test
ON [dbo].[Table_1]
FOR INSERT,UPDATE,DELETE
AS
BEGIN
SET NOCOUNT ON;
UPDATE T1 SET [recTriUdpTime] = GETDATE()
FROM [dbo].[Table_1] AS T1 INNER JOIN inserted AS T2 ON T1.recID = T2.recID
END
GO
—–触发器批量触发SQL脚本示例—–
CREATE TRIGGER tri_Test
ON [dbo].[Table_1]
FOR INSERT,UPDATE,DELETE
AS
BEGIN
SET NOCOUNT ON;
UPDATE T1 SET [recTriUdpTime] = GETDATE()
FROM [dbo].[Table_1] AS T1 INNER JOIN inserted AS T2 ON T1.recID = T2.recID
END
GO