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 Serialization in .NET? what are the types of Serialization?

555


How can we add relation between tables in a dataset?

547


What are dataproviders?

549


What are the parameters that control most of connection pooling behaviors?

515


Does dapper use ado.net?

598






What is basic use of data view?

511


What is two way data binding android?

489


What is oledb connection?

509


Define the data provider classes that is supported by ado.net?

519


What is shadow copy?

579


What are the parameters that control most of connection pooling behaviours?

574


What is the default Timeout for SqlCommand.CommandTimeout property?

508


How to find the given query is optimised one or not?

508


Which is faster dataset or datareader?

528


What are the steps you will take to improve performance?

463