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 are all the different methods under sqlcommand?

682


What are the connected and disconnected modes in ado.net?

681


What is the maximum pool size in ado.net connection string?

676


What is the purpose of using adodb?

676


Command objects uses, purposes and their methods.

692






What are the steps you will take to improve performance? Will you use dataset or datareader?

728


What is the current version of entity framework?

647


Which method is used to sort the data in ADO.Net?

1724


What is microsoft ado.net?

754


What is sql connection in ado.net?

676


how Sequence to connect and retrieve data from database using dataset?

921


What is the difference between Optimistic and Pessimistic locking?

725


What is the difference between sqldatareader and sqldataadapter?

674


What is an orm, and why would you use one instead of plain old ado.net?

777


What is the difference between executenonquery () and executescalar ()?

666