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


Please Help Members By Posting Answers For Below Questions

What are sub reports and how to create them?

113


What is the main purpose of having conversation group?

694


What is the difference between commit and rollback?

702


What is difference between table aliases and column aliases? Do they affect performance?

740


How to convert a numeric expression from one data type to another?

725


What is an indexing strategy?

738


What is coalesce in sql server?

758


How do I edit a stored procedure in sql server?

709


What is the command dbcc checkdb used for?

736


What are the difference between primary keys and foreign keys?

731


How to generate create table script on an existing table in ms sql server?

878


What are indexes in ms sql server?

746


What are the new data types are introduced in sql 2000?

698


Explain an automatic checkpoint

741


How to sort the query output with order by clauses in ms sql server?

844