Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between Triggers and Stored Procedure
- 23 Answers
- 73617 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
Explain what are the basic functions for master, msdb, model, tempdb databases?
What is shared lock?
What is self join in sql server joins?
What are types of scd? : sql server analysis services, ssas
What is the difference between the application object and session object?
Do you know how to send email from database?
What is the difference between grant and with grant while giving permissions to the user?
How to run sql server 2005 books online on your local system?
Where is localdb stored?
How global temporary tables are represented and its scope?
What are the differences in Clustering in SQL Server 2005 and 2008 or 2008 R2?
What is oltp (online transaction processing)?
What is the use of RDBMS?
What are horizontal and vertical scaling?
What are scheduled tasks in sql server?
