Difference between Triggers and Stored Procedure
- 23 Answers
- 67001 Views
- Claimat, HCL, Protech, Silgate, I also Faced
- E-Mail Answers
Answer Posted / vikas sinha
1)Stored Procedure can call.but trigger is automatically
invoked when action defined in trigger is done.
2)Stored procedure can not be inactive.but trigger can be
active and inactive.
3)Stored Procedure may or may not reture a value.but
trigger will not return a value.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What is inner join? Explain with an example?
What is the difference between dropping a database and taking a database offline?
What is log shipping? Can we do logshipping with SQL Server 7.0 ?
How to write the storeprocedure with in the store procedure? and how can we write the store procedure with in a trigger vice versa? plz post me the exact answer?
What is cursor in ms sql server?
What are the five characteristics of good data?
Explain the etl (extraction, transformation, and loading)?
Do you know the cursor optimization tips?
What does this statement do @@rowcount?
Tell me what is log shipping?
Explain the microsoft sql server delete command?
How to transfer a table from one schema to another?
Does union all remove duplicates?
How to create an index on a view?
What are the advantages of using stored procedures in sql server?
