Trigger in SqlServer

Question

Hi How can we define Trigger in SqlServer and define Syntax?

Priya Linge · Answer

Hi Please check below link which will help to understand the Trigger in SqlServer. http://www.sqlteam.com/article/an-introduction-to-triggers-part-i http://en.wikipedia.org/wiki/Database_trigger Hope this will help you. Thanks.

Prabhu Raja · Answer

Hi The Basic Syntax of trigger is CREATE TRIGGER trigger_name ON {table_name|view_name}[WITH ENCRYPTION] {FOR|AFTER|INSTEAD OF} [INSERT] [] [UPDATE] [] [DELETE] As sql_statements Check out this Article : http://www.c-sharpcorner.com/uploadfile/shashikantray/create-delete-and-update-triggers-in-a-database/

Javeed M Shaikh · Answer

Hi Rajesh Following is an example of INSERT Trigger in SQL Server: CREATE TRIGGER myTrigger ON myTable FOR INSERT AS // your code comes here