Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between Triggers and Stored Procedure
- 23 Answers
- 72615 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
What are the types of stored procedures in an sql server?
What is the downside of using udf?
what is difference between NULL and ISNULL in SQL Server 2008?
Differentiate sql server reporting services vs. Crystal reports?
Why are views required in the sql server or in any other database?
What are indexes in sql?
What is create command?
What is the difference between function and stored procedure in sql server?
What is the cartesian product of table?
Do you know what are acid properties?
Explain nested stored procedure. Syntax and an example for create nested stored procedure?
What are data regions?
Explain about Joins?
Explain foreign key in sql server?
What is user-defined multi-statement table-valued function?
