PROCEDURES AND STANDARD FUNCTIONS IN SQL
Keywords:
SQL, Stored Procedures, Function, Optional parameter, Parameterized Queries, SQL Server Management Studio, MySQL Workbench.Abstract
A SQL function is a pre-written, reusable code block to perform a specific task. It is created and stored in the database and can be called from an SQL statement or another function. A SQL procedure is a pre-written, reusable code block designed to perform a specific task or set of tasks.
References
Patrick O’Neil and Elizabeth O’Neil, Database Principles, Programming and Performance, Harcourt Asia Pte. Ltd., First Edition, 2001.
Peter Rob and Carlos Coronel, Database Systems Design, Implementation and Management, Thomson Learning-Course Technology, Seventh Edition, 2007.
C. J. Date, A. Kannan and S. Swamynathan, An Introduction to Database Systems, Pearson Education, Eighth Edition, 2009.
Abraham Silberschatz, Henry F. Korth and S. Sudarshan, Database System Concepts, McGraw-Hill Education (Asia), Fifth Edition, 2006.
Atul Kahate, Introduction to Database Management Systems, First Edition, 2006
