Test your technical skills online, appear in Virtual Interview and be ready for job!
Twitter Twitter LinkedIn YouTube Google
Be Interview ready ! | Search
Make friends on DotNetFunda.com and expand your network!
Winners

Win Prizes

Announcements
Like us on Facebook
Sponsor
Top Articles Author
Wed, 16-Apr-2014 Authors
All Time Authors
Rajkatie
20480
Vishal@Neeraj
19600
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: 13578 | 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.

Comments / Responses
Select text & click toolbar to format. Formatting appears in viewmode only. HTML Tags are not allowed.
Bold Italic Underline Paragraph Title Code  Link 
 Wait ... Processing ..... please wait.