SQLUtilities - Summary
by TotallySQL - Product Type: Component / .NET Class / 100% Managed Code
Summary
SQLUtilities by TotallySQL
URLs: sqlutilities, totallysql
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.
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.
Powerful functions for string, date and time manipulation.
Pricing: SQLUtilities - CAL (Client Access License) V1.0 1 CAL License, SQLUtilities - CAL (Client Access License) V1.0 5 CAL License, SQLUtilities - CAL (Client Access License) V1.0 10 CAL License, SQLUtilities - CAL (Client Access License) V1.0 25 CAL License, SQLUtilities - CAL (Client Access License) V1.0 50 CAL License, SQLUtilities - CAL (Client Access License) V1.0 with - 1 Year Support & Maintenance 1 CAL License, SQLUtilities - CAL (Client Access License) V1.0 with - 1 Year Support & Maintenance 5 CAL License, SQLUtilities - CAL (Client Access License) V1.0 with - 1 Year Support & Maintenance 10 CAL License, SQLUtilities - CAL (Client Access License) V1.0 with - 1 Year Support & Maintenance 25 CAL License, SQLUtilities - CAL (Client Access License) V1.0 with - 1 Year Support & Maintenance 50 CAL License, SQLUtilities - CAL (Client Access License) V1.0 with - 3 Year Support & Maintenance 1 CAL License, SQLUtilities - CAL (Client Access License) V1.0 with - 3 Year Support & Maintenance 5 CAL License, SQLUtilities - CAL (Client Access License) V1.0 with - 3 Year Support & Maintenance 10 CAL License, SQLUtilities - CAL (Client Access License) V1.0 with - 3 Year Support & Maintenance 25 CAL License, SQLUtilities - CAL (Client Access License) V1.0 with - 3 Year Support & Maintenance 50 CAL License, SQLUtilities - CAL (Client Access License) V1.0 with - 5 Year Support & Maintenance 1 CAL License, SQLUtilities - CAL (Client Access License) V1.0 with - 5 Year Support & Maintenance 5 CAL License, SQLUtilities - CAL (Client Access License) V1.0 with - 5 Year Support & Maintenance 10 CAL License, SQLUtilities - CAL (Client Access License) V1.0 with - 5 Year Support & Maintenance 25 CAL License, SQLUtilities - CAL (Client Access License) V1.0 with - 5 Year Support & Maintenance 50 CAL License, SQLUtilities CAL (Client Access License) - 1 Year Support & Maintenance Renewal 1 CAL Support & Maintenance Renewal License, SQLUtilities CAL (Client Access License) - 1 Year Support & Maintenance Renewal 5 CAL Support & Maintenance Renewal License, SQLUtilities CAL (Client Access License) - 1 Year Support & Maintenance Renewal 10 CAL Support & Maintenance Renewal License, SQLUtilities CAL (Client Access License) - 1 Year Support & Maintenance Renewal 25 CAL Support & Maintenance Renewal License, SQLUtilities CAL (Client Access License) - 1 Year Support & Maintenance Renewal 50 CAL Support & Maintenance Renewal License, SQLUtilities CAL (Client Access License) - 3 Year Support & Maintenance Renewal 1 CAL Support & Maintenance Renewal License, SQLUtilities CAL (Client Access License) - 3 Year Support & Maintenance Renewal 5 CAL Support & Maintenance Renewal License, SQLUtilities CAL (Client Access License) - 3 Year Support & Maintenance Renewal 10 CAL Support & Maintenance Renewal License, SQLUtilities CAL (Client Access License) - 3 Year Support & Maintenance Renewal 25 CAL Support & Maintenance Renewal License, SQLUtilities CAL (Client Access License) - 3 Year Support & Maintenance Renewal 50 CAL Support & Maintenance Renewal License, SQLUtilities CAL (Client Access License) - 5 Year Support & Maintenance Renewal 1 CAL Support & Maintenance Renewal License, SQLUtilities CAL (Client Access License) - 5 Year Support & Maintenance Renewal 5 CAL Support & Maintenance Renewal License, SQLUtilities CAL (Client Access License) - 5 Year Support & Maintenance Renewal 10 CAL Support & Maintenance Renewal License, SQLUtilities CAL (Client Access License) - 5 Year Support & Maintenance Renewal 25 CAL Support & Maintenance Renewal License, SQLUtilities CAL (Client Access License) - 5 Year Support & Maintenance Renewal 50 CAL Support & Maintenance Renewal License, SQLUtilities - CPU License V1.0 1 CPU License, SQLUtilities - CPU License V1.0 2 CPU License, SQLUtilities - CPU License V1.0 4 CPU License, SQLUtilities - CPU License V1.0 8 CPU License, SQLUtilities - CPU License V1.0 Unlimited CPU License, SQLUtilities - CPU License V1.0 with - 1 Year Support & Mai
Evals & Downloads: Read the SQLUtilities help file, Read the TotallySQL License Agreement, Download the SQLUtilities V1.0 evaluation on to your computer - Expires After 30 Days
Operating System for Deployment: Windows 7, Windows Server 2008, Windows Server 2003
Architecture of Product: 32Bit, 64Bit
Product Type: Component
Component Type: .NET Class, 100% Managed Code
Compatible Containers: Microsoft SQL Server 2008, Microsoft SQL Server 2005
Keywords: SQLUtilities
totally sql
SQL query language
Part numbers: PC-541740-407666 541740-407666 PC-541740-407667 541740-407667 PC-541740-407668 541740-407668 PC-541740-407669 541740-407669 PC-541740-407670 541740-407670 PC-541740-407671 541740-407671 PC-541740-407672 541740-407672 PC-541740-407673 541740-407673 PC-541740-407674 541740-407674 PC-541740-407675 541740-407675 PC-541740-407676 541740-407676 PC-541740-407677 541740-407677 PC-541740-407678 541740-407678 PC-541740-407679 541740-407679 PC-541740-407680 541740-407680 PC-541740-407681 541740-407681 PC-541740-407682 541740-407682 PC-541740-407683 541740-407683 PC-541740-407684 541740-407684 PC-541740-407685 541740-407685 PC-541740-407686 541740-407686 PC-541740-407687 541740-407687 PC-541740-407688 541740-407688 PC-541740-407689 541740-407689 PC-541740-407690 541740-407690 PC-541740-407691 541740-407691 PC-541740-407692 541740-407692 PC-541740-407693 541740-407693 PC-541740-407694 541740-407694 PC-541740-407695 541740-407695 PC-541740-407696 541740-407696 PC-541740-407697 541740-407697 PC-541740-407698 541740-407698 PC-541740-407699 541740-407699 PC-541740-407700 541740-407700 PC-541740-407946 541740-407946 PC-541740-407947 541740-407947 PC-541740-407948 541740-407948 PC-541740-407949 541740-407949 PC-541740-407950 541740-407950 PC-541740-407951 541740-407951 PC-541740-407952 541740-407952 PC-541740-407953 541740-407953 PC-541740-407954 541740-407954 PC-541740-407955 541740-407955 PC-541740-407956 541740-407956 PC-541740-407957 541740-407957 PC-541740-407958 541740-407958 PC-541740-407959 541740-407959 PC-541740-407960 541740-407960 PC-541740-407961 541740-407961 PC-541740-407962 541740-407962 PC-541740-407963 541740-407963 PC-541740-407964 541740-407964 PC-541740-407965 541740-407965 PC-541740-407966 541740-407966 PC-541740-407967 541740-407967 PC-541740-407968 541740-407968 PC-541740-407969 541740-407969 PC-541740-407970 541740-407970 PC-541740-407971 541740-407971 PC-541740-407972 541740-407972 PC-541740-407973 541740-407973 PC-541740-407974 541740-407974 PC-541740-407975 541740-407975 PC-541740-407976 541740-407976 PC-541740-407977 541740-407977 PC-541740-407978 541740-407978 PC-541740-407979 541740-407979 PC-541740-407980 541740-407980