Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

WHAT IS TRIGGERS IN SQL? AND WHAT IS THE BENIFIT?

Answer Posted / ashish tripathi

A trigger is a stored procedure that goes into effect when
you insert, delete, or update data in a table. You can use
triggers to perform a number of automatic actions, such as
cascading changes through related tables, enforcing column
restrictions, comparing the results of data modifications,
and maintaining the referential integrity of data across a
database.

Is This Answer Correct ?    12 Yes 5 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is scrollable cursor?

1080


What is temporary stored procedure?

987


How can you control the amount of free space in your index pages?

1100


How to optimize stored procedures in sql server?

1240


What area unit the various kinds of info compression introduced in sql server 2008?

1136


What happens if we shrink log file in sql server?

1030


What is a derived table?

990


What are the differences between INNER JOIN, LEFT JOIN and RIGHT JOIN in SQL Server?

1178


what are triggers? : Sql server database administration

951


What are the different Topologies in which Replication can be configured?

1237


What are the advantages of using cte?

1073


What is the importance of concurrency control?

1271


Explain activity monitors

1129


What are the restrictions that views have to follow? : SQL Server Architecture

1058


How to modify existing triggers using "alter trigger"?

1064