Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between Triggers and Stored Procedure
- 23 Answers
- 74275 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
How many categories of functions based their return modes?
Where the sql logs gets stored?
What are the restraints imposed on the table design by a merge replication?
What is a trigger? Why we need it?
difference between Clustered index and non clustered index ?
Explain tables in SQL Azure?
What is a select query statement in ms sql server?
Do you know what is openxml in sql server?
How many null values we can have in a unique key field in sql server?
Who developed sql server?
what is the main function of a query parameter?
What are views used for?
What is an execution plan?
What are the pre-defined functions in the sql server?
What is shrink log file?
