MSSQL Server Skill

How to use this skill

1. Identify the topic using the routing table below (keyword → file mapping).
2. Read the relevant reference file(s). Never answer from memory alone when a reference file covers the topic.
3. Cross-cutting questions — identify ALL matching rows and read each file. Check "See Also" sections for additional files.
4. Ambiguous keywords — read the "Disambiguation" column. When in doubt, load both files.
5. Response format: Lead with code/pattern, follow with caveats in admonition blocks, end with source links.

Quick Examples

-- Basic filtered query with pagination
SELECT CustomerName, Email
FROM Customer
WHERE Status = 'Active'
ORDER BY CustomerName
OFFSET 0 ROWS FETCH NEXT 25 ROWS ONLY;