Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between Triggers and Stored Procedure
- 23 Answers
- 73440 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 is indexing explain it with an example?
Explain rdbms?
Does an index slow down updates on indexed columns?
How to automatically create a log when an exception is being received into SQL Server?
What is model database? : SQL Server Architecture
What is transaction server implicit?
How do users use Report Builder with SQL Server data sources?
how would you troubleshoot blocking? : Sql server database administration
Explain the difference between delete,drop and truncate in SQL Server?
Explain the disadvantages of cursors?
What is the process of indexing?
Do you know what is raid and what are different types of raid configurations? : SQL Server Architecture
Where are stored procedures in sql server?
what is database replicaion? : Sql server database administration
How to use "begin ... End" statement structures in ms sql server?
