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 

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

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

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

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: