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

Where are sql server user names and passwords stored in sql server?

1088


How to get the definition of a view out of the sql server?

987


What is cte (common table expression)?

1032


How to get a list of all tables with "sys.tables" view in ms sql server?

1032


What is db stored procedure?

880


Name the different type of indexes in sql?

963


How to find out what is the default collation in a database?

1121


How to insert multiple rows with one insert statement in ms sql server?

1122


What is user-defined functions? What are the types of user-defined functions that can be created?

1034


Beginning with sql server version 7 0, a new enhanced data type nchar was added what type of data is supported with this data type?

1011


What is nolock?

983


How you can minimize the deadlock situation?

1037


What is ssl in sql server?

1072


What happens if null values are involved in bitwise operations?

1024


How to verify a login name with sqlcmd tool?

1217