What are the Advantages of using SQL Triggers ?
Posted by Chvrsri on 1/7/2011 | Category: Sql Server Interview questions | Views: 7461 | Points: 40
Different Advantages of Using SQL Triggers :
. It can catch the errors in business logic at the database level.
. It provides an alternative way to run scheduled tasks.
. It is very much useful when we use it to audit the change the data in a database table.
. Using SQL trigger,we don’t have to wait to run the scheduled tasks. we can handle
those tasks before or after changes being made to database tables.
. It provides an alternative way to check integrity.
Source: My Own !!! | Asked In: Many Interviews