Difference between Triggers and Stored Procedure
- 23 Answers
- 69287 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
How to create an inline table-valued function?
Which trace flags are enabled in sql server?
What is auditing in sql server?
How do I open a .db file?
What is update locks?
what is the information that can be stored inside a bit column? : Sql server database administration
What is identity?
How to loop through the result set with @@fetch_status?
What are distributed partitioned views?
What do you understand by SQL*Net?
How to set the current database in ms sql server?
How can we solve concurrency problems?
Can sub report data source be different from that of the parent report?
What is sql service broker?
How to loop through result set objects using odbc_fetch_row()?
