Difference between Triggers and Stored Procedure

Answer Posted / naveen jindal

trigger fired implicitely that is when ever events like
insert/update/delete commands.

Where as stored procedure is not fired implicitely. when
ever we call then only the stored procedure fire.

Is This Answer Correct ?    6 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

query processing

1921


What is database replication?

757


What is a bit datatype?

736


Define synonym?

902


Detail about the hardware which is supported by SQL server?

755






How to start and end transact-sql statements?

747


Can you explain what is indexed view? How to create it?

717


What is deploy, process and build? : sql server analysis services, ssas

748


What is stored in the mssqlsystemresource database? : sql server database administration

777


What are parameterized reports?

176


How to integrate the ssrs reports in application?

714


Does sql server 2016 have ssms?

714


What is shrink log file?

653


What is hot add cpu in sql server 2008?

697


how to create a scrollable cursor with the scroll option? : Sql server database administration

769