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

Explain the concept of recursive stored procedure.

876


How to return the top 5 rows from a select query in ms sql server?

1069


Differentiate between a having clause and a where clause.

922


What is master database? : SQL Server Architecture

946


What do you mean by table and field in sql?

965


Explain what is analysis service repository?

922


Explain user defined functions?

942


What language is sql server written in?

980


What is the difference between varchar and varchar types?

996


What are the properties of the transaction?

968


what are defaults? : Sql server database administration

1002


What is meant by dirty read?

947


How to generate create view script on an existing view?

944


What are the different types of normalization?

1083


How to retrieve error messages using odbc_errormsg()?

983