Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between Triggers and Stored Procedure
- 23 Answers
- 72697 Views
- Claimat, HCL, Protech, Silgate, I also Faced
- E-Mail Answers
Answer Posted / thirupathi
1. Triggers are implicitly called by DB itself while SP has to be manually called by user.
2. SP can pass the parameters which is not a case with Triggers.
3. While creating a Trigger, triggering event n action has to be specified, which isn’t a case with SP.
4. A Trigger can call the specific SP in it but the reverse is not true.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Is null vs coalesce?
What are the joins in sql server? : sql server database administration
How do I connect to sql server database?
Does partitioning help performance?
What is subquery? Explain the properties of a subquery?
What is the purpose of self join?
Explain the xml support sql server extends?
In what three ways is the return statement used in a stored procedure?
What is an identity?
What is reportserver and reportservertempdb ?
List the different normalization forms?
When would you use a before or after trigger?
List the types of recovery model available in sql server?
What are the properties and different types of sub-queries?
Is it ok to shrink transaction log?
