MSSQL CREATE TRIGGER

Create a trigger in ms-sms:

First right-click the Triggers folder icon in the table

Then enter the trigger creation directive, the case: (Add creation time)

Create:

SETAnsi_nulls onGOSETQuoted_identifier onGO-- =============================================--Author: <Author,,Name>--Create Date: <create date,,>--Description: <Description,,>-- =============================================CREATE TRIGGER [dbo].[TRIGGER_GFSBJ]    on  [dbo].[Product]     for INSERT as BEGIN    UpdateO_productSetPro_itime= getdate() fromO_product asDInner JoinInserted asI onD.id=i.idENDGO

After creation:

 Use [GFSBJ]GO/** * * * Object:trigger [dbo].    [TRIGGER_GFSBJ] Script date:05/08/2016 13:04:21 * * * * **/SETAnsi_nulls onGOSETQuoted_identifier onGO-- =============================================--Author: <Author,,Name>--Create Date: <create date,,>--Description: <Description,,>-- =============================================ALTER TRIGGER [dbo].[TRIGGER_GFSBJ]    on  [dbo].[Product]     for INSERT as BEGIN    UpdateO_productSetPro_itime= getdate() fromO_product asDInner JoinInserted asI onD.id=i.idEND

MSSQL CREATE TRIGGER