Difference between Triggers and Stored Procedure

Answer Posted / pankaj arya

To use stored procedure you have to make a call to that
procedure but Triggers fired automatically when an event is
occurred on the table associated with that Trigger like add,
insert or delete.

Is This Answer Correct ?    108 Yes 7 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain active/passive and active/active cluster configurations?

625


How to delete multiple rows with one delete statement in ms sql server?

515


What are commonly used odbc functions in php?

536


Explain different types of locks in sql server.

596


What is SQL Azure Firewall?

116






What language is sql server written in?

527


What is clr ddl trigger?

549


What are the tool windows in sql server management studio? : sql server management studio

620


How to use copy and concatenate commands in SQL?

599


You want to generate a report that is formatted as a chart. Can you use the report wizard to create such a report?

88


How would we use distinct statement? What is its use?

603


What is the difference between function and stored procedure in sql server?

483


List the different types of joins?

566


What is change data capture (cdc) in sql server 2008?

564


What are the difference between primary keys and foreign keys?

538