Difference between Triggers and Stored Procedure
- 23 Answers
- 69317 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
Difference between report and query parameter.
Why it is recommended to avoid referencing a floating point column in the where clause?
What is mscorsvw.exe - process - microsoft .net framework ngen?
Can we linked SharePoint to a SQL database?
Do you know what are acid properties of transaction?
What are Spatial data types in SQL Server 2008
What is cursors? And what are the different types of cursor?
What is it unwise to create wide clustered index keys?
What is the purpose of linked server configuration in sql server?
How do you delete a trigger?
Write an SQL query to obtain the 2nd highest salary.
How do you delete duplicate records in sql server?
How to name query output columns in ms sql server?
what are different types of backups available in sql server? : Sql server database administration
what is a self join? : Sql server database administration
