Difference between Triggers and Stored Procedure
- 23 Answers
- 69282 Views
- Claimat, HCL, Protech, Silgate, I also Faced
- E-Mail Answers
Answer Posted / ghanshyam vrema
1. SP may Return a value but Trigger Not,
2. In SP you can pass parameter But in trigger you can't
3. we explicitly call the Sp when Trigger are implicitly
fired
4. you can write a sp in Trigger but in a Trigger you cant
write SP.
5. Trigger written on an individual Table or View where SP
is written for an Database
| Is This Answer Correct ? | 75 Yes | 43 No |
Post New Answer View All Answers
What is @@rowcount in sql?
What is transaction server distributed transaction?
How to sort query output in descending order in ms sql server?
Can we add a cpu to sql server?
What is the difference between mysql and sql server?
What are different replication agents and what's their purpose? : sql server replication
What is the dbcc command and why is it used?
How to create new tables with "create table" statements in ms sql server?
What is a recursive stored procedure in sql server?
What is format parameter in ssrs?
Does partitioning improve performance?
Tell me about builtinadministrator?
How will you decide the active and passive nodes?
What is triggers and its types?
What are the differences between decimal and float in ms sql server?
