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
What is the difference between stored procedure and functions?
What is a transactions?
How to change parameter value inside the report?
What is the use of @@spid?
Explain indexing and what are the advantages of it?
Explain the characteristics of a transaction server for example atomicity, consistency, isolation, durability?
What is the purpose of update statistics and scope_identity() function?
What are the aggregate and scalar functions?
can you implement data mining in SSRS?
Define clusters?
What is the difference between index seek vs. Index scan?
How sql server executes a statement with nested subqueries?
how many clustered indexes can be created on a table? : Sql server database administration
What is clustered primary key?
How to transfer an existing table from one schema to another schema in ms sql server?