Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between Triggers and Stored Procedure
- 23 Answers
- 74277 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
Explain how to integrate the ssrs reports in application?
how to overcome kernel isssues
What are different types of constraints?
Can you force a query to use a specific index?
Explain the use of containers in ssis and also their types?
What is store procedure?
What is triggers and its types?
Explain concepts of analysis services?
What kind of problems occurs if we do not implement proper locking strategy?
What is autocommit mode in sql server?
How to change parameter value inside the report?
What are null values in ms sql server?
How does the report manager work in SSRS?
How to set database to be single_user in ms sql server?
What is the default sql server instance name?
