Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between Triggers and Stored Procedure
- 23 Answers
- 73583 Views
- Claimat, HCL, Protech, Silgate, I also Faced
- E-Mail Answers
Answer Posted / avdhesh yadav
1. Stored Procedure may Return a value but Trigger Not,
2. In Stored Procedure you can pass parameter But in
trigger you can't
3. we explicitly call the Stored Procedure when Trigger are
implicitly
fired
4. you can write a Stored Procedure in Trigger but in a
Trigger you cant
write Stored Procedure.
5. Trigger written on an individual Table or View where
Stored Procedure
is written for an Database
| Is This Answer Correct ? | 29 Yes | 7 No |
Post New Answer View All Answers
What are user-defined functions (udfs) in sql server?
What is difference between temp table and cte?
How to drop existing indexes in ms sql server?
what's sql server? : Sql server database administration
What is read uncmmited?
What is normalization according to you and explain its different levels?
What are the parts of a function?
What is a group function explain with an example?
How to declare and use cursor variables?
What are sp_configure commands and set commands?
What number aggregate functions are accessible there in sql?
What are parameterized reports?
What is a virtual table in sql?
Explain system views?
How do I edit a procedure in sql server?
