Difference between Triggers and Stored Procedure

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


Please Help Members By Posting Answers For Below Questions

What is the difference between stored procedure and functions?

818


What is a transactions?

799


How to change parameter value inside the report?

133


What is the use of @@spid?

775


Explain indexing and what are the advantages of it?

781


Explain the characteristics of a transaction server for example atomicity, consistency, isolation, durability?

784


What is the purpose of update statistics and scope_identity() function?

853


What are the aggregate and scalar functions?

765


can you implement data mining in SSRS?

127


Define clusters?

836


What is the difference between index seek vs. Index scan?

803


How sql server executes a statement with nested subqueries?

743


how many clustered indexes can be created on a table? : Sql server database administration

816


What is clustered primary key?

788


How to transfer an existing table from one schema to another schema in ms sql server?

726