SQLUtilities extends the T-SQL scripting environment
by adding 64 new general-purpose functions for text,
date/time and numeric processing that can be used
directly within queries and stored procedures at the
database layer.

Date and time functions include table-valued sequence
generator functions that can generate 'on-the-fly'
date and/or time sequences of any length with any step
interval (these can be used directly in joins, for
example), random date and/or time generators, various
working days calculations that take into account
specified weekend days and holidays, and other general
date and time arithmetic functions to complement
what's already available in SQL.

Numeric functions include a table-valued numeric
sequence generator that can generate 'on the fly'
numeric sequences of any length and interval, a
RANDBETWEEN function similar to the one in MS Excel,
and a RANDOM function that does not require seeding

Download (522 KB) Website Link to this page