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

•

Database Management

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.

Key Features

01Version-specific function tracking for SQL Server 2005 through 2022

02Comprehensive window function patterns including LAG, LEAD, and IGNORE NULLS

037 GitHub stars

04Modern string manipulation techniques using STRING_AGG and STRING_SPLIT

05Native JSON and XML processing patterns for relational-document workflows

06Advanced date grouping and bucketing logic for time-series analysis

Use Cases

01Migrating legacy T-SQL code to modern standards using SQL Server 2022 enhancements

02Optimizing analytical queries with partitioned window functions and frame specifications

03Implementing robust JSON parsing and generation within stored procedures

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add josiahsiegel/claude-plugin-marketplace tsql-functions

For use in Claude.ai and ChatGPT

Download Skill