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

How to provide default values to function parameters?

1140


Explain sql server authentication modes?

1134


What are the approximate numeric data types?

936


What is a covering index?

985


What is nonclustered index on computed columns?

960


how to do partition in sqlserver

2475


what is the maximum size of a row? : Sql server database administration

1015


What do you understand by replication in sql server? Mention the different types of replication in sql server.

947


Can we add a cpu to sql server?

1014


What is used to replicate sessions between instances in coldfusion clusters?

1072


Explain four layers of abstraction microsoft architectured?

147


List layers of abstraction microsoft architectured to provide relational db through cloud platform ?

183


Can I run multiple instances of sql server 2000 at the same time on one computer?

1074


Suppose we have a table "MyTable" containing 10 rows, what query should be executed to update the odd rows "Salary" as 9000?

986


How you can minimize the deadlock situation?

1042