Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between Triggers and Stored Procedure
- 23 Answers
- 73618 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 dimension table? : sql server analysis services, ssas
Do you know nested transaction?
What do you mean by data manipulation language?
What is abstracting periodical?
What is trigger and different types of Triggers?
How to create a simple table to test triggers in ms sql server?
What are the transaction properties?
System requirements for sql server 2005 express edition?
What are sub reports?
What is an index in a database?
How to write a query with a right outer join in ms sql server?
What is dirty page?
What is table-valued sub query?
How do I create a trace in sql server?
What is the difference between writing data to mirrored drives versus raid5 drives
