Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between Triggers and Stored Procedure
- 23 Answers
- 72712 Views
- Claimat, HCL, Protech, Silgate, I also Faced
- E-Mail Answers
Answer Posted / shilpa
triggers are fired automatically when any event ocours like
update ,delete ,insert on a table
whereas sp is set of sql statements its not related to
single table but its can have many sql satements that can
be used in many tables to update, delete and insert .
| Is This Answer Correct ? | 7 Yes | 2 No |
Post New Answer View All Answers
What do I need to start working with sql studio? : sql server management studio
How to generate create function script on an existing function?
What is spatial and temporal data?
Is it possible to import data directly from t-sql commands without using sql server integration services? If so, what are the commands?
What is the correct order of the logical query processing phases?
What is a field name?
Explain external key management in sql server 2008
What is the full meaning of dml?
How to select all columns of all rows from a table with a select statement in ms sql server?
What is the difference between nvl and nvl2?
What is difference between delete and truncate commands?
Explain what is “asynchronous” communication in sql server service broker?
How can we solve concurrency problems?
List layers of abstraction microsoft architectured to provide relational db through cloud platform ?
What is Extended user-defined?
