what is trigger?

Answer Posted / roopesh kumar

A trigger is a DB object like proc. or func. stored in data
dictonary. It will fire implicitly with event on which it
written.

Main use of a trigger are

-- we can take backup of data.
-- Can be used for auditing purpose.
-- For applying complex bussiness rule.
Etc.

Is This Answer Correct ?    3 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is an ado?

627


What is ole2 format?

578


What are different layers of ADO.Net?

680


Which is faster dataset or datareader?

630


What is difference between connected and disconnected architecture in ado.net?

686






How to copy the contents from one table to another table and how to delete the source table in ado.net?

617


What are the several execute methods of ado.net?

590


How to maintain the relation between two tables in ADO.NET?

621


What is ado.net and its architecture?

590


Some important instruction regarding ADO.NET connection string ?

628


What is dataset and datatable in ado.net?

597


How many major types of connection objects in ADO.NET?

694


What are the different namespaces used in the project to connect the database? What data providers available in .net to connect to database?

871


What is difference between datareader and dataadapter?

643


Is datareader faster than datatable?

618