What are stored procedures, and how do they differ from triggers?

Posted by

To view Verified answers click on the button below.

A stored procedure is a program that is stored within the database and is compiled when
used. They can receive input parameters and they can return results. Unlike triggers, their
scope is database-wide; they can be used by any process that has permission to use the
database stored procedure.