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

How to drop an existing schema in ms sql server?

672


Does windows server 2016 come with sql server?

587


How do I create a stored procedure in sql server?

605


What is sql or structured query language?

767


What does the automatic recovery do?

677






Can you explain different types of joins?

633


What is the use of builtinadministrators group in sql server? : sql server security

628


Write an sql query for deleting duplicate rows?

637


How many types of stored procedures are there in sql server?

649


How to find the version of sql server? : sql server database administration

710


What is report rendering ?

109


Is natural join and equi join same?

617


How can we determine what objects a user-defined function depends upon?

593


Explain aggregate functions?

678


What are the types of database recovery models?

673