Does it include examples for JSON processing?

Yes, it provides patterns for JSON_VALUE, OPENJSON, and the new JSON_OBJECT and JSON_ARRAY functions introduced in SQL Server 2022.

Can I use this for window function syntax?

Absolutely, it includes a detailed reference for ROW_NUMBER, RANK, LAG, LEAD, and complex frame-specific windowing operations.

What versions of SQL Server does this skill support?

The skill provides guidance for functions starting from SQL Server 2005 up to the latest features in SQL Server 2022 and Azure SQL Database.

How does this help with string manipulation?

It provides modern, NULL-safe syntax for functions like CONCAT_WS, STRING_AGG, and STRING_SPLIT with ordinal support.

T-SQL Functions Master

Name: T-SQL Functions Master
Author: JosiahSiegel

byJosiahSiegel

•

データベース管理

Provides a comprehensive reference and implementation patterns for T-SQL functions across SQL Server and Azure SQL Database versions.

概要

The T-SQL Functions skill is a specialized tool for database developers and administrators working within the Microsoft SQL Server ecosystem. It offers immediate access to syntax, version-specific availability, and advanced implementation patterns for a wide range of functions including string manipulation, date/time arithmetic, and complex windowing operations. Whether you are leveraging the latest SQL Server 2022 features like GENERATE_SERIES or handling legacy window functions, this skill ensures your code is efficient, modern, and compatible with your target environment.

主な機能

Version-specific function tracking for SQL Server 2005 through 2022
Comprehensive window function patterns including LAG, LEAD, and IGNORE NULLS
7 GitHub stars
Modern string manipulation techniques using STRING_AGG and STRING_SPLIT
Native JSON and XML processing patterns for relational-document workflows
Advanced date grouping and bucketing logic for time-series analysis

ユースケース

Migrating legacy T-SQL code to modern standards using SQL Server 2022 enhancements
Optimizing analytical queries with partitioned window functions and frame specifications
Implementing robust JSON parsing and generation within stored procedures

概要

主な機能

Version-specific function tracking for SQL Server 2005 through 2022
Comprehensive window function patterns including LAG, LEAD, and IGNORE NULLS
7 GitHub stars
Modern string manipulation techniques using STRING_AGG and STRING_SPLIT
Native JSON and XML processing patterns for relational-document workflows
Advanced date grouping and bucketing logic for time-series analysis

ユースケース

Migrating legacy T-SQL code to modern standards using SQL Server 2022 enhancements
Optimizing analytical queries with partitioned window functions and frame specifications
Implementing robust JSON parsing and generation within stored procedures