SQL SERVER 2008 – What are the pros and cons of using triggers

Most Expected answer:

A trigger is one or more statements of SQL that are being executed in event of data modification in a table to which the trigger belongs.

Mainly Triggers enhance the security, efficiency, and standardization of databases.
Triggers can be beneficial when used:
– to check or modify values before they are actually updated or inserted in the database. This is useful if you need to transform data from the way the user sees it to some internal database format.
– to run other non-database operations coded in user-defined functions
– to update data in other tables. This is useful for maintaining relationships between data or in keeping audit trail information.
– to check against other data in the table or in other tables. This is useful to ensure data integrity when referential integrity constraints aren’t appropriate, or when table check constraints limit checking to the current table only.

Reference : Dilip Kumar Jena ( https://sqlexplore.wordpress.com )

Advertisements

6 thoughts on “SQL SERVER 2008 – What are the pros and cons of using triggers

  1. keep up the fantastic work , I read few articles on this internet site and I conceive that your site is really interesting and has got lots of fantastic info .
    some genuinely great info , Glad I discovered this.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s