SQLUtilities for Windows

Name: SQLUtilities
Rating: 4 (1 reviews)
Author: TotallySQL

By TotallySQL
Trial version
User Rating

Download now

Key Details of SQLUtilities

Get Microsoft SQL Server text, date/time & numeric functions library
Last updated on 05/25/11
There have been 0 updates within the past 6 months
The current version has 0 flags on VirusTotal

Developer’s Description

By TotallySQL

Get Microsoft SQL Server text, date/time & numeric functions library.

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 between query rows in order to generate distinct random numbers. In addition there are three relative-column reference functions that allow you to eaily retrieve the value of one column from the row in which the maximum value, the minimum value, or a specified value of another column occurs.