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.
System Requirements:
WinXP, WinVista, WinVista x64, Win7 x32, Win7 x64, WinServer
Version:
1.0.0.0
Last updated:
2011-05-13 07:44:50
Publisher:
TotallySQL Ltd
Homepage:
http://www.totallysql.comFile name:
SQLUtilities.zip
File size:
0.5MB
License:
Shareware
Price:
199