What is trigger ?

Answer Posted / abdulla

Trigger is Limited form stored procedure associated with tables.

Is This Answer Correct ?    0 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the difference between delete and truncate statements?

746


Explain index in sql server?

754


What is database mirroring?

752


What is relationship? What number of sorts of relationship are there?

820


Which sql server table is used to hold the stored procedure script?

662






How to set the current database in ms sql server?

719


What is the maximum row of a size?

766


Explain magic tables in sql server?

723


How to delete duplicate rows in sql server?

776


How do you start single user mode in clustered installations?

704


You have a stored procedure, which execute a lengthy batch job. This stored procedure is called from a trigger you do not want to slow the data entry process you do not want trigger to wait for this batch job to finish before it completes itself what you can do to speed up the process?

854


What are the types of subquery?

735


What is difference between materialized view and view?

685


What is difference between aggregate and analytic function?

655


What are the pros and cons of putting a scalar function in a queries select list or in the where clause?

948