SQL Server Tigger

Really helpless obviously a lot of things clearly I just write a website let me go to the database don't say refueling

Create statement

1     UseTig2    GO3    Create Trigger [Trigger Name]  on [Table name]4    [Trigger Conditions]( for Insert/ for Update/AfterInsert/AftertUpdate)5     as6    Print 'Output'

Example

1     Use Tig 2    GO 3    Create Trigger  on A 4    Insert 5     as 6    Print ' Insert A '

Check all the trigger

1    Select *  from where xtype='TR'

Query the specified trigger

1     exec [trigger name ]

Delete the specified trigger

1     Drop Trigger [trigger name ]

SQL Server Tigger