SQL
User Defined Functions
Functions return a value and can be used inside a query. Learn CREATE FUNCTION, determinism, the difference from procedures, and the performance trap.
#Stored Procedures
Procedural code stored in the database.
2 notes tagged
SQL
Stored Procedures and Parameters
Named procedural code stored in the database. Learn CREATE PROCEDURE, IN, OUT and INOUT parameters, control flow, and when a procedure is the right to...