Types of Trigger Storage in SQL

Tychons has a large pool of experienced and skilled professionals with finest talents and customer oriented attitudes for delivering customized solutions of high quality with a great speed and at a competitive cost.  Our employee’s doesn’t hesitate to share useful information and always follow the words of Winston Churchill "If you have knowledge, let others light their candles with it." Here is one of the useful information shared by our employee.

Triggers:-

 They are two types of trigger.

1)      Before Trigger.

2)     After Trigger.

“BEFORE” AND “AFTER” Triggers are used to modify the data in the table. 

Where the modified values are stored in SQL and how to retrieve it?

1) “DELETED” keyword used to retrieve value from “BEFORE/AFTER Trigger UPDATE”  Process.

2)  “DELETED” keyword used to retrieve value from “BEFORE/AFTER Trigger DELETE”   Process.

3) “INSERTED” keyword used to retrieve value from “BEFORE/AFTER Trigger INSERT” Process.