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


Please Help Members By Posting Answers For Below Questions

Explain steps of normalization?

793


What is statement level trigger?

796


Differentiate between ms sql server reporting services vs crystal reports?

715


can an order by clause be used in a creation of a view?

928


Can we use where clause in union?

847


What is inline table-value user-defined function?

827


What is the syntax to execute the sys.dm_db_missing_index_details? : sql server database administration

890


What is default port number for sql server 2000?

808


What are the underflow and overflow behaviors on float literals?

866


What is the synonym of join?

743


Tell me what is the difference between locking and multi-versioning?

821


What are clustered and non-clustered index?

754


How do you identify a foreign key?

821


Difference between connected and disconnected database in .net with sql server?

831


What is 'Join' and explain its various types.

853