Difference between Triggers and Stored Procedure
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 are sub reports and how to create them?
What is the main purpose of having conversation group?
What is the difference between commit and rollback?
What is difference between table aliases and column aliases? Do they affect performance?
How to convert a numeric expression from one data type to another?
What is an indexing strategy?
What is coalesce in sql server?
How do I edit a stored procedure in sql server?
What is the command dbcc checkdb used for?
What are the difference between primary keys and foreign keys?
How to generate create table script on an existing table in ms sql server?
What are indexes in ms sql server?
What are the new data types are introduced in sql 2000?
Explain an automatic checkpoint
How to sort the query output with order by clauses in ms sql server?