Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between Triggers and Stored Procedure
- 23 Answers
- 73276 Views
- Claimat, HCL, Protech, Silgate, I also Faced
- E-Mail Answers
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 do you mean by an execution plan? Why is it used? How would you view it?
What is the difference between grant and with grant while giving permissions to the user?
How do I start sql server 2016?
What is difference between cte and view?
What is a functions and types in sql server?
Why do we partition data?
What is optimistic concurrency?
How check triggers in sql server?
How do I save a stored procedure in sql server?
Why do we use functions?
Can we return Data from 4(more than 1) tables in stored procedure?
How to create a new schema in a database?
How to drop an existing user defined function in ms sql server?
On a windows server 2003 active – passive failover cluster, how do you find the node which is active?
How will you make an attribute not process? : sql server analysis services, ssas
