Answer Posted / kalyana chakravarthy maddipati
A trigger is a stored procedure fires implicitly when ever a DML(Insert, update & Delete) occurs. It is stored at server side. Its compiled and no need to compile and execute always.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Will sql server 2005 allow you to reduce the size of a column?
What are indexers?
What to perform pattern match with the like operator?
Explain Capacity planning to create a database? and how to monitor it?
What command would you use to add a column to a table in sql server?
How will you decide the active and passive nodes?
What is “asynchronous” communication in sql server service broker?
Please illustrate physical database architecture? : SQL Server Architecture
What is a print index?
What are trace flags and mention a few common trace flags used with sql server?
What is database mirroring?
What are the properties of primary key?
How do I install sql server?
What is a result set object returned by odbc_exec()?
How many primary keys are possible in a table?
