Difference between Triggers and Stored Procedure
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
How to reaname table name without using sp_Rename in sql server..?
Can you leave a union at any time?
What are points to remember while using the fillfactor argument?
How do you size a resultset?
after migrating the dts packg to ssis by using migrtn wizrd in 2005. iam not able to open ssis pack and getting error. what r those errors? how to resolve?
What is the difference between implicit and explicit transaction?
What is an indexing strategy?
How to delete existing rows in a table?
What is the filtered index?
Explain different types of locks in sql server.
What is code near application topology?
what happens on checkpoint? : Sql server database administration
Determine how to use the inserted and deleted pseudo tables?
What is dirty read?
What are triggers in ms sql server?