skills.homes logoskills.homescapability registry
home/categories/sql-databases/josiahsiegel-claude-plugin-marketplace-plugins-tsql-master-skills-advanced-patterns-skill-md
cd ..
sql-databasesdatabases

advanced-patterns

Advanced T-SQL patterns and techniques for SQL Server. Use this skill when: (1) User needs help with CTEs or recursive queries, (2) User asks about APPLY operator, (3) User wants MERGE or OUTPUT clause help, (4) User works with temporal tables, (5) User needs In-Memory OLTP guidance, (6) User asks about advanced grouping (ROLLUP, CUBE, GROUPING SETS).

View Sourcesql-databases
JosiahSiegel
maintainer
JosiahSiegel
Updated 1/8/2026
Stars
23
Forks
3
quick start

Installation and usage

Advanced T-SQL patterns and techniques for SQL Server. Use this skill when: (1) User needs help with CTEs or recursive queries, (2) User asks about APPLY operator, (3) User wants MERGE or OUTPUT clause help, (4) User works with temporal tables, (5) User needs In-Memory OLTP guidance, (6) User asks about advanced grouping (ROLLUP, CUBE, GROUPING SETS).

Installation
$ install --globalskills.sh
Usage

Once installed, you can use this skill by running the following command in your terminal:

skills use advanced-patterns