Difference between Triggers and Stored Procedure

Answer Posted / ram

Stored Procedures are called by the programmer wherever it
wants to fire but triggers fired automatically when
insert,delete,update occured. And triggers can be
implemented to tables & views only where as s.p used in the
database independently

Is This Answer Correct ?    135 Yes 13 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is mssql?

765


how to determine the service pack currently installed on sql server? : Sql server database administration

780


How to get all stored procedures in sql server?

734


What is query optimizer in sql server?

781


What is service broker? : sql server database administration

799


Explain logical operators in sql server?

810


What are the advantages to use stored procedures?

847


Why the trigger fires multiple times in single login?

917


What do mean by xml datatype?

819


What is cursor in ms sql server?

831


Can I disable or restrict ssrs export formats (rendering formats)?

126


What is the difference between substr and charindex in the sql server?

736


How to configure odbc dsn with different port numbers?

809


What is the process of normalising?

802


The external application that is executed in one of the tasks does not have a log file, but only a screen log. How can I save the data from the screen? : sql server management studio

765