Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between Triggers and Stored Procedure
- 23 Answers
- 73476 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 insert new line characters into strings?
What are some of the pros and cons of not dropping the sql server builtinadministrators group? : sql server security
How much is a sql server license?
What is sparse columns of sql server 2008?
What is the difference between osql and query analyzer?
What is triggers in ms sql server?
What is the language structure to add a record to a table?
How to resolve the orphan use problem? : sql server security
How to create a large table with random data for index testing in ms sql server?
What do you understand by mirroring and mention the advantages of the mirroring?
What is the data tier application?
What is the maximum number of instances in 32 bit and 64 bit sql server 2012?
Tell me what is the order in which the sql query is executed?
Is foreign key unique?
How to update a field in SQL after ALTERING a row?
