#stored-procedures

SQL Stored Procedures vs Functions: Choosing Wisely

When to use stored procedures, when to use functions, and how transaction control, return values, and side effects differ across major databases.