Difference between Triggers and Stored Procedure
- 23 Answers
- 69338 Views
- Claimat, HCL, Protech, Silgate, I also Faced
- E-Mail Answers
Answer Posted / madhu prakash p
sp and trigger are both predefined set of sql statements
we can pass the arguments for sp but we cant pass the
arguments for triggers.
trigger will fire implicitly, when ever relavent action
performed by the user on the tables where the triggers are
placed.
But in the stored procedures u must call explicitly.
| Is This Answer Correct ? | 43 Yes | 9 No |
Post New Answer View All Answers
Explain what are the basic functions for master, msdb, model, tempdb databases?
What does it mean to manipulate data?
How can you start sql server in different modes?
What is ssrs?
What is exclusive locks?
What is the main purpose of having conversation group?
What is spatial and temporal data?
Explain a differential backup?
What is factless fact table? : sql server analysis services, ssas
What is log cache in sql server?
What is attribute relationships, why we need it? : sql server analysis services, ssas
What part does database design plays a role in performance of an sql server-based application?
Which language rdl files made of?
what is denormalization and when would you go for it? : Sql server database administration
In what version of sql server were synonyms released?
