We are hiring, contact us.

Win Prizes

Social Presence
Twitter Twitter LinkedIn YouTube Google

Like us on Facebook
Top Articles Author
Tue, 28-Apr-2015 Authors
All Time Authors
Bharathi Cherukuri

Latest members | More ...

(Statistics delayed by 5 minutes)
 Interview Question

What are the Advantages of using SQL Triggers ?

 Posted by Chvrsri on 1/7/2011 | Category: Sql Server Interview questions | Views: 17596 | 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 | Alert Moderator 

Share this to:

Bookmark It

Comments or Responses

Posted by: Muhsinathk on: 9/13/2012 | Points: 10

Advantages of Trigger

1.Faster application development. Because the database stores triggers, you do not have to code the trigger actions into each database application.
2.Global enforcement of business rules. Define a trigger once and then reuse it for any application that uses the database
3.Easier maintenance. If a business policy changes, you need to change only the corresponding trigger program instead of each application program.
4.Improve performance in client/server environment. All rules run in the server before the result returns.
5.Triggers can be used to enforce constraints

Login to post response