Complete reference for all T-SQL function categories with version-specific availability.
| CONCAT(str1, str2, ...) | NULL-safe concatenation | 2012+ | | CONCATWS(sep, str1, ...) | Concatenate with separator | 2017+ | | STRINGAGG(expr, sep) | Aggregate strings | 2017+ | | STRINGSPLIT(str, sep) | Split to rows | 2016+ | | STRINGSPLIT(str, sep, 1) | With ordinal column | 2022+ | | TRIM([chars FROM] str) | Remove leading/trailing | 2017+ |
| TRANSLATE(str, from, to) | Character replacement | 2017+ | | FORMAT(value, format) | .NET format strings | 2012+ |
Complete T-SQL function reference for SQL Server and Azure SQL Database. Use this skill when: (1) User asks about T-SQL string, date, math, or conversion functions, (2) User needs help with window/ranking functions, (3) User works with JSON or XML in T-SQL, (4) User asks about aggregate functions or GROUP BY, (5) User needs system or metadata functions. Source: josiahsiegel/claude-plugin-marketplace.