Code Library

Some simple static analysis queries for Microsoft SQL Server (2005, 2008, 2012)
These queries perform some very basic checks for commonly encountered problems in SQL Server table designs and index implementation. Each query identifies a different type of issue - no rows returned = no problem found.

dbo.GenInsert
Proc to generate INSERT or MERGE statements from data in a table. SQL Server.

dbo.drawtable
Proc draws a tabular, fixed-width representation of a query result. SQL Server.

A calendar-generating query using a recursive CTE
A calendar / time dimension template for Microsoft SQL Server 2008, 2012
UK holidays data for the calendar

Password generator (MS SQL Server 2016)

Text concatenation aggregate
Concatenates rows of text into a single value

Product aggregate
Returns the product of a table of integers. Adapted from a similar idea by Joe Celko

Alphanumeric key generator
Sequence generator for an incrementing key with alpha and numeric parts

ISO country codes (SQL-92 compatible)

ISO currency codes (SQL-92 compatible)