Difference between Triggers and Stored Procedure
Answer Posted / pramod bansode
1> For executing Sp we have to call Stored Procedure. But in
case of Trigger it is call whenever there is an action taken
on table or column(Insert, Update ,Delete).
2> From SP we pass Values But from Trigger we cant.
3> stored procedure returns value but trigger cannot returns
value.
4> For SP we have to compile. for Trigger no need to compile.
5> we return SP in Trigger but Trigger can not be in SP.
Is This Answer Correct ? | 18 Yes | 8 No |
Post New Answer View All Answers
What is the syntax for encrypting a column in SQL Server?
How to turn off warning messages during php execution?
How to find the second highest salary of an employee?
How to create a dynamic cursor with the dynamic option?
What is set nocount on and what is set nocount off?
If you want to send some data from access database to sql server database. What are different component of ssis will you use?
What is a select query statement in ms sql server?
What is difference between rownum and rowid?
Explain few of the new features of sql server 2008 management studio
How to return the top 5 rows from a select query in ms sql server?
Do you know what is blocking?
What is the web service used for reporting services?
What is difference between group by and having?
What are the three different part of rdl file explain them?
How can a user-defined datatype be created?