tsql-functions
Installation
SKILL.md
T-SQL Functions Reference
Complete reference for all T-SQL function categories with version-specific availability.
Quick Reference
String Functions
| Function | Description | Version |
|---|---|---|
CONCAT(str1, str2, ...) |
NULL-safe concatenation | 2012+ |
CONCAT_WS(sep, str1, ...) |
Concatenate with separator | 2017+ |
STRING_AGG(expr, sep) |
Aggregate strings | 2017+ |
STRING_SPLIT(str, sep) |
Split to rows | 2016+ |
STRING_SPLIT(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+ |