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
What are all the different methods under sqlcommand?
What are the connected and disconnected modes in ado.net?
What is the maximum pool size in ado.net connection string?
What is the purpose of using adodb?
Command objects uses, purposes and their methods.
What are the steps you will take to improve performance? Will you use dataset or datareader?
What is the current version of entity framework?
Which method is used to sort the data in ADO.Net?
What is microsoft ado.net?
What is sql connection in ado.net?
how Sequence to connect and retrieve data from database using dataset?
What is the difference between Optimistic and Pessimistic locking?
What is the difference between sqldatareader and sqldataadapter?
What is an orm, and why would you use one instead of plain old ado.net?
What is the difference between executenonquery () and executescalar ()?