SQLUtilities
by TotallySQL - Product Type: Component / .NET Class / 100% Managed Code
Powerful functions for string, date and time manipulation. SQLUtilities extends and enhances your T-SQL programming environment by adding: 21 date and time related functions, including a table-valued date and time sequence generator; random date and time generators; working days calculations; date and time arithmetic; formatting, parsing and type conversion, 37 string and text processing functions including string concatenation functions and aggregates; scalar and table-valued tokenized string parsing; advanced formatting, searching and substitution; regular expressions processing; collation-free comparisons; type conversions., 3 useful numeric functions - including a table-valued numberline sequence generator - allowing you to generate any required set of incremental numeric values of any size on the fly without having to create and maintain lookup tables, and two excel-like random number generators that are easier to use than the built-in T-SQL RAND() function and 3 relative column reference aggregate functions, allowing you to select values from multiple columns in an aggregation from the row that contains the maximum, minimum or a matching value of one column.
Our regular prices are shown below. Please logon to see your discounted prices.
SQLUtilities - CAL (Client Access License) V1.0
SQLUtilities - CAL (Client Access License) V1.0 with - 1 Year Support & Maintenance
SQLUtilities - CAL (Client Access License) V1.0 with - 3 Year Support & Maintenance
SQLUtilities - CAL (Client Access License) V1.0 with - 5 Year Support & Maintenance
SQLUtilities CAL (Client Access License) - 1 Year Support & Maintenance Renewal
| Add to Cart |
$ 29.20 |
1 CAL Support & Maintenance Renewal License |
Verify |
Download (494 KB) |
| Add to Cart |
$ 97.80 |
5 CAL Support & Maintenance Renewal License |
Verify |
Download (494 KB) |
| Add to Cart |
$ 156.60 |
10 CAL Support & Maintenance Renewal License |
Verify |
Download (494 KB) |
| Add to Cart |
$ 293.80 |
25 CAL Support & Maintenance Renewal License |
Verify |
Download (494 KB) |
| Add to Cart |
$ 489.80 |
50 CAL Support & Maintenance Renewal License |
Verify |
Download (494 KB) |
SQLUtilities CAL (Client Access License) - 3 Year Support & Maintenance Renewal
| Add to Cart |
$ 58.41 |
1 CAL Support & Maintenance Renewal License |
Verify |
Download (494 KB) |
| Add to Cart |
$ 195.61 |
5 CAL Support & Maintenance Renewal License |
Verify |
Download (494 KB) |
| Add to Cart |
$ 313.21 |
10 CAL Support & Maintenance Renewal License |
Verify |
Download (494 KB) |
| Add to Cart |
$ 587.61 |
25 CAL Support & Maintenance Renewal License |
Verify |
Download (494 KB) |
| Add to Cart |
$ 979.61 |
50 CAL Support & Maintenance Renewal License |
Verify |
Download (494 KB) |
SQLUtilities CAL (Client Access License) - 5 Year Support & Maintenance Renewal
| Add to Cart |
$ 87.61 |
1 CAL Support & Maintenance Renewal License |
Verify |
Download (494 KB) |
| Add to Cart |
$ 293.41 |
5 CAL Support & Maintenance Renewal License |
Verify |
Download (494 KB) |
| Add to Cart |
$ 469.81 |
10 CAL Support & Maintenance Renewal License |
Verify |
Download (494 KB) |
| Add to Cart |
$ 881.41 |
25 CAL Support & Maintenance Renewal License |
Verify |
Download (494 KB) |
| Add to Cart |
$ 1,469.41 |
50 CAL Support & Maintenance Renewal License |
Verify |
Download (494 KB) |
SQLUtilities - CPU License V1.0
| Add to Cart |
$ 2,449.02 |
1 CPU License |
|
Download (494 KB) |
| Add to Cart |
$ 3,919.02 |
2 CPU License |
|
Download (494 KB) |
| Add to Cart |
$ 5,879.02 |
4 CPU License |
|
Download (494 KB) |
| Add to Cart |
$ 9,795.10 |
8 CPU License |
|
Download (494 KB) |
| Add to Cart |
$ 15,674.12 |
Unlimited CPU License |
|
Download (494 KB) |
SQLUtilities - CPU License V1.0 with - 1 Year Support & Maintenance
| Add to Cart |
$ 2,938.82 |
1 CPU License |
|
Download (494 KB) |
| Add to Cart |
$ 4,702.82 |
2 CPU License |
|
Download (494 KB) |
| Add to Cart |
$ 7,054.82 |
4 CPU License |
|
Download (494 KB) |
| Add to Cart |
$ 11,754.12 |
8 CPU License |
|
Download (494 KB) |
| Add to Cart |
$ 18,808.94 |
Unlimited CPU License |
|
Download (494 KB) |
SQLUtilities - CPU License V1.0 with - 3 Year Support & Maintenance
| Add to Cart |
$ 3,428.63 |
1 CPU License |
|
Download (494 KB) |
| Add to Cart |
$ 5,486.63 |
2 CPU License |
|
Download (494 KB) |
| Add to Cart |
$ 8,230.63 |
4 CPU License |
|
Download (494 KB) |
| Add to Cart |
$ 13,713.14 |
8 CPU License |
|
Download (494 KB) |
| Add to Cart |
$ 21,943.77 |
Unlimited CPU License |
|
Download (494 KB) |
SQLUtilities - CPU License V1.0 with - 5 Year Support & Maintenance
| Add to Cart |
$ 3,918.43 |
1 CPU License |
|
Download (494 KB) |
| Add to Cart |
$ 6,270.43 |
2 CPU License |
|
Download (494 KB) |
| Add to Cart |
$ 9,406.43 |
4 CPU License |
|
Download (494 KB) |
| Add to Cart |
$ 15,672.16 |
8 CPU License |
|
Download (494 KB) |
| Add to Cart |
$ 25,078.59 |
Unlimited CPU License |
|
Download (494 KB) |
SQLUtilities CPU License - 1 Year Support & Maintenance Renewal
| Add to Cart |
$ 489.80 |
1 CPU Support & Maintenance Renewal License |
Verify |
Download (494 KB) |
| Add to Cart |
$ 783.80 |
2 CPU Support & Maintenance Renewal License |
Verify |
Download (494 KB) |
| Add to Cart |
$ 1,175.80 |
4 CPU Support & Maintenance Renewal License |
Verify |
Download (494 KB) |
| Add to Cart |
$ 1,959.02 |
8 CPU Support & Maintenance Renewal License |
Verify |
Download (494 KB) |
| Add to Cart |
$ 3,134.82 |
Unlimited CPU Support & Maintenance Renewal License |
Verify |
Download (494 KB) |
SQLUtilities CPU License - 3 Year Support & Maintenance Renewal
| Add to Cart |
$ 979.61 |
1 CPU Support & Maintenance Renewal License |
Verify |
Download (494 KB) |
| Add to Cart |
$ 1,567.61 |
2 CPU Support & Maintenance Renewal License |
Verify |
Download (494 KB) |
| Add to Cart |
$ 2,351.61 |
4 CPU Support & Maintenance Renewal License |
Verify |
Download (494 KB) |
| Add to Cart |
$ 3,918.04 |
8 CPU Support & Maintenance Renewal License |
Verify |
Download (494 KB) |
| Add to Cart |
$ 6,269.65 |
Unlimited CPU Support & Maintenance Renewal License |
Verify |
Download (494 KB) |
SQLUtilities CPU License - 5 Year Support & Maintenance Renewal
| Add to Cart |
$ 1,469.41 |
1 CPU Support & Maintenance Renewal License |
Verify |
Download (494 KB) |
| Add to Cart |
$ 2,351.41 |
2 CPU Support & Maintenance Renewal License |
Verify |
Download (494 KB) |
| Add to Cart |
$ 3,527.41 |
4 CPU Support & Maintenance Renewal License |
Verify |
Download (494 KB) |
| Add to Cart |
$ 5,877.06 |
8 CPU Support & Maintenance Renewal License |
Verify |
Download (494 KB) |
| Add to Cart |
$ 9,404.47 |
Unlimited CPU Support & Maintenance Renewal License |
Verify |
Download (494 KB) |
Our prices include ComponentSource technical support and, for most downloadable products, an online backup and a FREE upgrade to the new version if it is released within 30 days of your purchase. All sales are made on our standard Terms and Conditions and subject to our Return Policy. Please contact us if you require any licensing option not listed, including volume licensing and previous versions.
Our regular prices are shown above. Please logon to see your discounted prices.
SQLUtilities includes:
- 21 date and time related functions, including a table-valued date and time sequence generator (allowing you to generate any required set of incremental dates or times of any size on the fly without having to create and maintain lookup tables); random date and time generators; working days calculations; date and time arithmetic; formatting, parsing and type conversion.
- 37 string and text processing functions including string concatenation functions and aggregates; scalar and table-valued tokenized string parsing; advanced formatting, searching and substitution; regular expressions processing; collation-free comparisons; type conversions.
- 3 very useful numeric functions - including a table-valued numberline sequence generator - allowing you to generate any required set of incremental numeric values of any size on the fly without having to create and maintain lookup tables, and two excel-like random number generators that are easier to use than the built-in T-SQL RAND() function.
- 3 relative column reference aggregate functions, allowing you to select values from multiple columns in an aggregation from the row that contains the maximum, minimum or a matching value of one column.
Beyond Excel
Some of the functions in SQLUtilities are similar in name and function to the date and string processing functions found in Microsoft Excel and similar packages - although generally with significantly expanded functionality and range. There are also many others that are over and above what can be found in Excel. Combined with the innate power and ability of SQL Server to rapidly crunch through huge volumes of data - this gives you a data processing capability that completely blows away anything you could do with spreadsheets.
Easy to Use
All TotallySQL Transact-SQL extensions are implemented using familiar programming objects within SQL (scalar and table-valued functions, aggregate functions, user-defined types, stored procedures) , keeping the syntax clean and making them as fast and easy to use as the built-in native functions such as LTRIM and DATEADD.
SQLUtilities Features
- Return a table of numbers increasing / decreasing at set intervals between two bounds.
- Return a random float between 0 & 1 or a random integer between 2 bounds. No seeding.
- Return a table of dates, times or datetimes at any fixed interval between two bounds.
- Generate a random date, a random time or a random datetime between two bounds.
- Strip out the time or the date component of a datetime, leaving the date only or time only.
- Constructors for date, time and datetimes based on components (year, month, day etc).
- Return start date or end date of the month that is n months before or after the starting date.
- Count of working days between two dates, or in a given month, allowing for weekends & holidays.
- Detect whether a given day is a working day, allowing for weekends & holidays.
- Find date of first working day that is n working days before or after given date.
- Add fractional number of days to a datetime (e.g. 1.5 days = 18 hours).
- Detect whether given date is the last day of month, or whether given year is a leap year.
- Return date of nth occurence of mth weekday in a given month - e.g. 3rd Tuesday.
- Accurate conversion between SQL datetime values and Excel datetime serial numbers
- Count of total days in given month
- Format any SQL type as a string using .NET format specifier strings (e.g. "dd-mm-yyyy").
- Concatenate 2 strings or aggregate strings from multiple rows into a single, delimited string.
- Break delimited strings into tokens & return a table of them all, or a count, or a given token.
- Remove non-printing, punctuation, whitespace or listed characters from part or all of a string.
- Compare two strings for order or equality, ignoring collation, & case if specified.
- Flag if one string starts or ends with or contains another, ignoring collation & case if specified.
- Find first or last occurrence or count occurrences of one string in another, ignoring collation etc.
- Find first or last occurrence of any listed character in string.
- Remove n characters from string at position m, or insert substring at position m.
- Add spaces or other characters to start or end, or evenly, to pad string out to desired width.
- Parse a string as the specified SQL type & return as an object of that type (in a sql_variant)
- Find the first, nth or last match, flag if any match, or count matches, of regular expression in string.
- Return table of all matches to given regular expression in string, giving start, length & matched text. .
- Replace all matches to given regular expression with supplied replacement pattern.
- Return carriage return / line feed combination.
- Convert string to proper case (first letter of each word in upper case, rest in lower case).
- Return the value of one column at the maximum, minimum or specified value of another.
;)