Watch Our YouTube Channel
It is currently Mon Feb 19, 2018 11:35 am
 

All times are UTC



Post new topic Reply to topic  [ 2 posts ] 
Author Message
PostPosted: Fri Jul 15, 2016 7:25 am 
Online

Joined: Fri Nov 13, 2015 3:56 am
Posts: 462
A trigger in SQL is a sequence of actions which results in a change in the table of a database. It is activated when the contents of the table of a database are modified.

Advantages of trigger:
SQL triggers are very useful to audit the changes of data in tables.

Triggers are used for calling stored procedures.

It provides an alternate way to check integrity and run scheduled tasks.

SQL triggers can catch errors in business logic in the database layer.

Disadvantages of trigger:
Triggers increase the complexity of a database.

By the complex nature of the database programs take more time to execute.

Triggers run every time when the database fields are updated and it is overhead on system.

SQL triggers are invoked and executed invisible from the client applications, therefore, it is difficult to figure out what happen in the database layer.

_________________
Learn Web Development | Latest Technology News |Motivational Quotes


Top
 Profile  
Reply with quote  
PostPosted: Fri Oct 07, 2016 11:43 am 
Offline

Joined: Wed Jul 01, 2015 11:28 am
Posts: 172
Location: Bangalore
By using triggers, business rules and transactions are easy to store in database and can be used consistently even if there are future updates to the database. Programmers don’t have full control: Since business rules are hidden, programmers don’t have full control over the database. BY this, a program can generate several actions.

_________________
Digital Marketing Company in India| Web Design Company in India | SEO Services in India


Top
 Profile  
Reply with quote  
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 2 posts ] 

All times are UTC


Who is online

Users browsing this forum: No registered users and 1 guest


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to: