Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between Triggers and Stored Procedure
- 23 Answers
- 73465 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
Mention what are the different types of ssrs reports?
How can a user-defined datatype be created?
What is the purpose of floor function?
Define left outer join in sql server joins?
What is mean by dml?
What is difference between index seek vs. Index scan?
Explain the phases a transaction has to undergo?
what is blocking? : Sql server database administration
What is table value parameters (tvp)?
What are rows and columns?
How can you tell if a database object is invalid?
Explain DBCC?
Explain in brief about Microsoft SQL server?
What is a covering index?
What xml support does the sql server extend?
