Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between Triggers and Stored Procedure
- 23 Answers
- 72883 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
explain extended properties
Difference between group by clause and having clause in SQL?
Why truncate is ddl?
What is the bookmark lookup and rid lookup?
Explain what is raid and what are different types of raid levels?
What functions can a view be used to performed?
In what three ways is the return statement used in a stored procedure?
Explain left outer join and right outer join?
What are “unrepeatable reads”?
How to rebuild all indexes on a single table?
do views contain data ?
How to get a list of columns using the "sp_help" stored procedure in ms sql server?
Explain Normalization and DE normalization
What are types of storage modes? : sql server analysis services, ssas
What are the types of joins in sql?
