What are SQL stored procedures and how are they used?
What will be an ideal response?
An SQL stored procedure is a stored program that is attached to a database instead of just a table or view. Stored procedures can receive input parameters and return results. They can be executed by any process that has permission with the database to use stored procedures. They can issue SELECT, INSERT, UPDATE and DELETE commands. They are typically used by (1 ) database administrators to do common administrative tasks, and (2 ) database applications.
You might also like to view...
A mannequin dressed in a matching shirt, slacks, and sports jacket illustrates an ensemble display
Indicate whether the statement is true or false
________ leadership comes from being assigned to a position within the organization
A) Coercive B) Formal C) Referent D) Informal