Scalar User-defined functions (UDFs) - Procedural SQL

Description

Change History

1. 2026-07-21
   Feature Description Computation-based scalar UDFs now support WHILE loops multiple RETURN statements and deeply nested IF-THEN-ELSE blocks in the function body. They can also be used in queries that include Common Table Expressions (CTEs) and within GROUP BY HAVING and ORDER BY clauses. -> SQL native computation-based scalar UDFs now support WHILE loops multiple RETURN statements and deeply nested IF-THEN-ELSE blocks in the function body. They can also be used in queries that include Common Table Expressions (CTEs) and within GROUP BY HAVING and ORDER BY clauses. Name Scalar UDFs - Expanded T-SQL constructs and query shapes for computation-based UDFs -> Scalar User-defined functions (UDFs) - Procedural SQL
2. 2026-07-06
   Release Date 2026-06-30 -> 2026-09-30 Release Status Planned -> Shipped
3. 2026-06-16
   Restored to Roadmap
4. 2026-06-16
   Removed from Roadmap
5. 2026-05-13
   Feature Description We're expanding the capabilities of scalar user-defined functions. This update unlocks new scenarios for **computation**-based UDFs including support for while loops multiple return statements and complex control flows. Computation-based scalar UDFs can now be used in additional query shapes including Common Table Expressions (CTEs) and within GROUP BY HAVING and ORDER BY clauses. -> Computation-based scalar UDFs now support WHILE loops multiple RETURN statements and deeply nested IF-THEN-ELSE blocks in the function body. They can also be used in queries that include Common Table Expressions (CTEs) and within GROUP BY HAVING and ORDER BY clauses. Name Scalar User-defined functions (UDFs) - Complex control flows in computation-based UDFs -> Scalar UDFs - Expanded T-SQL constructs and query shapes for computation-based UDFs
6. 2026-04-23
   Roadmap Item Added