List some major differences between triggers and stored procedures?

devquora
devquora

Posted On: Feb 22, 2018

 

Following are some differences between stored procedures and triggers:
  • Event and actions needs to be identified at the time of creating a trigger. Whereas, at the time of creating a stored procedure, it is not important.
  • Trigger can be run automatically when any event occurs. Whereas, stored procedures have to be run manually.
  • A stored procedure can be called within a trigger. Whereas, a trigger cannot be called in a stored procedure.
  • Triggers execute implicitly. Whereas, stored procedures execute explicitly.
  • A trigger cannot be called from front end. Whereas, a stored procedure can be.

    Related Questions

    Please Login or Register to leave a response.

    Related Questions

    Stored Procedures Interview Questions

    What do you understand by a stored procedure?

    The group of SQL statements which are or have been stored in the server database is known as a stored procedure. Input ..

    Stored Procedures Interview Questions

    Mention the uses of stored procedures.

    Stored procedures are used for various different things. Some of the uses of stored procedures are as follows:Stored p..

    Stored Procedures Interview Questions

    What are the types of stored procedures in an SQL server?

    The types of stored procedures present in an SQL server are listed as follows: – User-defined stored procedures– th..