Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between Triggers and Stored Procedure
- 23 Answers
- 72610 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 is the process of indexing?
What are the different types of cursor?
What is a partition key?
What is a cursor, index in sql?
What are the limitations in ssrs on sql server express edition?
what is database replication? : Sql server database administration
What stored by the msdb? : sql server database administration
Explain the different index configurations a table can have?
How to list all objects in a given schema?
Write a program using SQL queries to find a unique entry in a table.
What is change data capture (cdc) in sql server 2008?
What is an sql server agent?
We need to perform what steps in the following order to work with a cursor?
How to backup SQL Server Reporting Services ?
What are the methods used to protect against sql injection attack?
