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 a mixed extent?

997


What is faster join or union?

1179


Tell me about normalization in DBMS.

983


You are designing a strategy for synchronizing an SQL Azure database and multiple remote Microsoft SQL Server 2008 databases. The SQL Azure database contains many tables that have circular foreign key relationships?

121


What are the basic functions for master, msdb, model, tempdb databases?

1024


What happens if you delete a table that is used by a view?

973


Can we insert data into a view?

1117


How many tables can be joined in SQL Server?

1045


How do you improve the performance of a SQL Azure Database?

137


Explain the difference between primary keys and foreign keys?

1003


How to add a new column to an existing table with "alter table ... Add" in ms sql server?

988


Define Wed Edition in SQL Azure?

100


Distinguish between nested subquery and correlated subquery?

1021


can a database be shrunk to 0 bytes, if not, why? : Sql server administration

1176


Name three of the features managed by the surface area configuration tool? : sql server security

976