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
Explain steps of normalization?
What is statement level trigger?
Differentiate between ms sql server reporting services vs crystal reports?
can an order by clause be used in a creation of a view?
Can we use where clause in union?
What is inline table-value user-defined function?
What is the syntax to execute the sys.dm_db_missing_index_details? : sql server database administration
What is default port number for sql server 2000?
What are the underflow and overflow behaviors on float literals?
What is the synonym of join?
Tell me what is the difference between locking and multi-versioning?
What are clustered and non-clustered index?
How do you identify a foreign key?
Difference between connected and disconnected database in .net with sql server?
What is 'Join' and explain its various types.