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

How to remove duplicate rows from table except one?

998


What are the differences between sql server and mysql.

1083


How can you ensure that the database and sql server based application perform well?

1061


What is extended stored procedures?

949


What is a data source or ds? : sql server analysis services, ssas

991


How connect excel to sql server?

982


what is a check constraint?

1081


How do I run a trace in sql server?

975


What are sp_configure commands and set commands?

1012


What is the maximum size of a row in sql server?

958


What is difference between after and before?

1069


What are sql dirty pages?

1010


What are the difference between “where” and “having” clause in sql server?

1061


What are logical/boolean operations in ms sql server?

1028


What command do we use to rename a db, a table and a column?

918