Difference between Triggers and Stored Procedure
- 23 Answers
- 69491 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
Can a unique index be created on a column, which contains null?
How to check if stored procedure is running in sql server?
How to find the list of fixed hard drive and free space on server?
What is sub-query in sql server? Explain its properties.
List types of tables in SQL Azure?
How to generate create function script on an existing function?
Can group by be used without aggregate functions?
What is a trigger and its types?
Working with TLogs
What can be used instead of trigger?
What are differences in between sql server 2012 and sql server 2016?
How to automatically create a log when an exception is being received into SQL Server?
What is federation member?
What is clr ddl trigger?
What is the template in sql?
