Search
Winners

Win Prizes

Social Presence
Twitter Twitter LinkedIn YouTube Google

Like us on Facebook
Advertisements
Top Articles Author
Fri, 25-Jul-2014 Authors
All Time Authors
Vishal@Neeraj
28480
Rajkatie
20600
Bharathi Cherukuri
18040

Latest members | More ...


(Statistics delayed by 5 minutes)

What are the Advantages of using SQL Triggers ?

 Posted by Chvrsri on 1/7/2011 | Category: Sql Server Interview questions | Views: 14869 | Points: 40

Answer:

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 

Found interesting? Add this to:



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