Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between Triggers and Stored Procedure
- 23 Answers
- 74259 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
How to select an exiting database using mssql_select_db()?
What is the purpose of indexing?
Can you explain what are the restrictions applicable while creating views? : SQL Server Architecture
What is mean by candidate key?
What are database states in ms sql server?
can you implement data mining in SSRS?
What is the cpu pressure?
How can you tell if a database object is invalid?
What is the use of nvl work?
What is command parameter in ssrs?
how to do partition in sqlserver
What is temporary table in sql server? Why we use temp table?
Explain log shipping and mention its advantages.
What is the difference between a function and a trigger?
Can group functions be used in the order by clause in ms sql server?
