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 / rami reddy.k

Triggers are the system generated events.
for example,
u have a table emp,in tat u can create a trigger which will
be activated if anyone performs any action such as insert,
update, delete on tat table.In tat trigger u can write code
which copies the updated info into another table.

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 ?    2 Yes 9 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Does a full backup include transaction log?

915


How to filter out duplications in the returning rows in ms sql server?

1069


What are the different types of columns types constraints in the sql server?

1014


What is database black box testing?

987


What is the process of indexing?

946


What is query cost in sql server?

938


What is mapping schema?

989


What are filegroups in sql server?

1014


Which rendering formats are affected by the pagesize properties?

134


Can you force a query to use a specific index?

890


How you can minimize the deadlock situation?

986


What is raid, and how it can influence database performance?

1010


What are the Advantages of using CTE in sql server?

1043


Explain linked server in sql?

1152


Tell me about the approaches which you used to counter the DI problems.

1272