mssql创建触发器

MS-SMS⾥创建触发器：⾸先右击表内的触发器⽂件夹图标

然后输⼊触发器创建指令，⼀下案例：（添加创建时间）创建：

SET ANSI_NULLS ONGO

SET QUOTED_IDENTIFIER ONGO

-- =============================================-- Author: -- Create date: -- Description:

-- =============================================CREATE TRIGGER [dbo].[trigger_gfsbj] ON [dbo].[product] FOR INSERTAS BEGIN

update o_product set pro_itime = getdate() from o_product as d inner join inserted as i on d.id=i.idENDGO

创建后：

USE [GFSBJ]GO

/****** Object: Trigger [dbo].[trigger_gfsbj] Script Date: 05/08/2016 13:04:21 ******/SET ANSI_NULLS ONGO

SET QUOTED_IDENTIFIER ONGO

-- =============================================-- Author: -- Create date: -- Description:

-- =============================================ALTER TRIGGER [dbo].[trigger_gfsbj] ON [dbo].[product] FOR INSERTAS BEGIN

update o_product set pro_itime = getdate() from o_product as d inner join inserted as i on d.id=i.idEND