Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between Triggers and Stored Procedure
- 23 Answers
- 73620 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 efficient you are in oracle and SQL server?
What is SQL Azure Data sync?
What is the partitioning method?
Tell me what is the stuff and how does it differ from the replace function?
What is code near application topology?
What are the differences between union, intersect, and minus operators?
What are blobs, tables, and Queues? Is SQL is the standard way to query blobs, tables, and queues?
what are the steps you will take to improve performance of a poor performing query? : Sql server database administration
What are the system database in sql server 2005?
What are the new security features added in sql server 2012? : sql server security
What are the advantages of having an index on the sql server?
What is deploy, process and build? : sql server analysis services, ssas
Explain primary key and foreign key constraints?
What are the difference between “where” and “having” clause in sql server?
How many databases can we create in a single server?
