1.

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

Answer»

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.



Discussion

No Comment Found

Related InterviewSolutions