SQL CLR Library , SQLCLR , CLR Routines , CLR Library , SQL Server CLR , Bulk Export , Regular Expressions , HTML Export , Generate Insert Statements 2012-5-19 0-48
SQL# / SQLsharp                   SQL #         Expanding the
capabilities of T-SQL

       Home       Features       Benefits       F.A.Q.       Download       Documentation       Contact Us 
  SQL CLR Library , SQLCLR , CLR Routines , CLR Library , SQL Server CLR , Bulk Export , Regular Expressions , HTML Export , Generate Insert Statements

Version 2.17.68 and 2.17.69 (May 6th, 2012)


  • Added Date function: Format (suggested by Dietmar Müller)
  • Added INET function: URIDecodePlus to extend the capabilities of URIDecode in two ways: 1) unescape %uXXYY-encoded Unicode characters which otherwise throw an error; and 2) gracefully handle errors, making set-based processing easier (suggested by Andy Krafft).
  • Added SQLsharp procedure: Download (replaces Update)
  • Updated INET_GetWebPages to allow "Content-Type" to be set via @CustomerHeader value. If set, the passed-in "Content-Type" will override the automatic value set when using the POST method (suggested by Michael Kuhl).
  • Updated DB_BulkExport: Improved handling of binary fields: a) drastic speed increase, and b) added missing "0x" prefix
  • Added String function: CompareSplitValues
  • Updated Convert_BinaryToHexString: Improved performance
  • Moved the following functions to Full version: String_SplitIntoFields, String_FixedWidthSplit, String_FixedWidthIndex, DB_BulkExport, DB_HTMLExport, and DB_ForEach.
  • Renamed String_SplitIntoFields to String_SplitResultIntoFields. String_SplitIntoFields is deprecated and will be replaced in the next version or two with a slightly different usage. Please switch any use of String_SplitIntoFields to point to String_SplitResultIntoFields.


Version 2.16.64 and 2.16.65 (October 19th, 2011)


  • Fixed error in installer that shows up when the collation setting for tempdb is not the same as the setting for the database in which SQL# is installed
  • Fixed minor error with SQLsharp_Uninstall (minor in that the error is reported but the uninstall still completes) that occurs when the database in which SQL# is installed has a case-sensitive collation
  • Updated INET_GetIPAddress to return NULL when NULL is passed in rather than error
  • Added INET function: INET_GetIPAddressList
  • Updated Date_BusinessDays and Date_IsBusinessDay to include two new holidays: Presidents' Day [US] (3rd Monday in February) (suggested by Claudio Pracilio) and Columbus Day [traditional] (October 12th)
  • Added Date function: Date_BusinessDaysAdd (suggested by Victor Wang)
  • Added RegEx function: RegEx_CaptureGroups (suggested by Jason Pierce)
  • Updated Date_BusinessDays to allow for StartDate to be greater than EndDate which will return a negative number, similar to how DATEDIFF works (suggested by Victor Wang)
  • Updated Date_BusinessDays to return NULL when any parameter is NULL rather than error
  • Added String functions: FixedWidthIndex (suggested by Don Folino) and FixedWidthSplit


Version 2.15.62 and 2.15.63 (August 31st, 2011)


  • Added RegEx functions: Escape, Index, and Unescape
  • Updated installer to remember security settings of previously installed assemblies
  • Updated File_SplitIntoFields and String_SplitIntoFields to accept a new, optional parameter for @DataTypes. The @DataTypes parameter allows you to set the specific data type of one or more of the fields in the result set. The default is still to create each field as NVARCHAR(MAX), but if you know that certain fields will always be a particular data type, then you can have all of the SplitIntoFields stored procedures return a more strongly-typed result set (which means doing fewer conversions later).
  • Added INET function: SplitIntoFields
  • Added new Sys group.
  • Added Sys function: Objects (server-wide view of sys.objects)
  • Updated File_SplitIntoFields to make @RowsToSkip parameter optional. The default is 0.


Version 2.14.60 and 2.14.61 (March 13th, 2011)


  • Updated String_IsNumeric to allow for “d” to be double-precision as well as not requiring the + or – for scientific notation
  • Added String functions: Replace, SplitKeyValuePairs, TrimChars, TrimEnd, and TrimStart
  • Updated Twitter Status-related Table-Valued Functions to return 7 geo fields: GetUserTimeline, GetPublicTimeline, GetFriendsTimeline, GetReplies, GetMentions, GetFavorites, GetMessages, and GetSentMessages
  • BREAKING CHANGE L: Updated Twitter_Update to accept optional Longitude and Latitude values for geocoding Tweets
  • Added Twitter functions: GetHomeTimeline, GetRetweetedBy, GetRetweetedByMe, GetRetweetedToMe, GetRetweets, GetRetweetsOfMe, and Retweet
  • BREAKING CHANGE L: Updated Twitter Status-related Table-Valued Functions to be able to pass in Twitter Optional Parameters: GetFriendsTimeline, GetFavorites, GetMentions, GetMessages, GetReplies, GetSentMessages, and GetUserTimeline as well as new functions GetHomeTimeline, GetRetweetedBy, GetRetweetedByMe, GetRetweetedToMe, GetRetweets, and GetRetweetsOfMe. See Manual entry for Twitter_GetUserTimeline for example of how to use Optional Parameters via Type_HashTable.
  • Deprecated Twitter_GetReplies in favor of GetMentions
  • Updated DB_BulkExport: added support for UTF7 as well as more datatypes: rowversion, date, time, datetime2, and datetimeoffset
  • Updated DB_DumpData: added support for UTF7 as well as more datatypes: rowversion, date, time, datetime2, and datetimeoffset
  • Updated DB_HTMLExport: added support for UTF7
  • Added new RunningTotal group (not available in Free version)
  • Added RunningTotal functions: Add, Get, CacheSize, and ClearCache
  • Added Util functions: HashBinary and IsValidConvert
  • Added Date functions: FullDateTimeString (not available in Free version) and NewDateTime
  • Updated Date_FullDateString and Date_FullTimeString to return NULL if input is NULL rather than error
  • Updated FILE functions to allow for full streaming and hence use much less memory: CopyMultiple, DeleteMultiple, GetDirectoryListing, and MoveMultiple
  • Updated RegEx_Split to stream results out
  • Updated Table-Valued RegEx functions to return NVARCHAR(MAX) for [Value] instead of NVARCHAR(4000): Match, Matches, and Split
  • Added INET function: DownloadFile
  • Added Math functions: CubeRoot, IEEERemainder, NthRoot, and Truncate
  • Added Convert functions: DateTimeToMSIntDate and MSIntDateToDateTime
  • Updated String_Split to fully stream output so it now uses less memory.


Version 2.13.55 and 2.13.56 (November 22nd, 2010)


  • Updated OS_EventLogWrite to accept NVARCHAR(MAX) for @Message as opposed to NVARCHAR(4000)
  • Updated OS_EventLogRead to return NVARCHAR(MAX) for Message as opposed to NVARCHAR(4000)
  • Added OS function: StartTime
  • Fixed Math_IsPrime as it was falsely reporting some large numbers as Prime that were not
  • Updated File_SplitIntoFields to add new parameter for @FileEncoding so that the user has full control over the encoding type.  Previously it was set to AutoDetect which did not always produce the correct result.
  • Updated File_WriteFile and File_WriteFileBinary to add “UTF7” as a FileEncoding option
  • Added File functions: CreateTempFile, GetDirectoryName, GetFileName, GetRootDirectory, and Touch


Version 2.12.53 and 2.12.54 (September 19th, 2010)


  • This release (2.12.x) is a Twitter API ONLY update.  No other changes have been made in this release!  If you do not use the Twitter functions and are on 2.11.x you do NOT need to upgrade.  However, if you are using the Twitter functions then you MUST upgrade to 2.12.x for the full OAuth implementation changes!  The Twitter functions in version 2.11.x will no longer work as of Monday, October 18th, 2010.
  • Please see the SQL# Twitter setup guide for details on how to set up your Twitter Application:
    http://www.SQLsharp.com/download/SQLsharp_TwitterSetup.pdf


Version 2.11.51 and 2.11.52 (June 19th, 2010)


  • Added Date functions: GetDateTimeFromIntVals, GetIntDate, and GetIntTime
  • Updated File_GZip and File_GUnzip: Replaced built-in .Net GZip and GUnzip libraries with external DotNetZip library for better compression and ZIP64 for > 4 GB files.
  • Fixed INET_URIDecode to properly translate "+" (plus-sign) into " " (space) which is not done by the built-in .Net library. [thanks to Andy Krafft]
  • Updated all RegEx functions to return NULL (or empty result set for the Table-Valued Functions, or 0 for RegEx_IsMatch) if ExpressionToValidate is passed in as NULL.  This behavior mirrors more closely the built-in T-SQL string functions. [thanks to Andy Krafft and Jason Pierce]
  • Updated RegEx_Split: Fixed output that was misreporting StartPos and EndPos fields when the "part" was empty (nothing between the delimiters).
  • Updated all String functions to return NULL (or empty result set for the Table-Valued Functions, or 0 for scalar functions that return a Boolean / BIT) if input string (or SearchValue if applicable) is passed in as NULL.  This behavior mirrors more closely the built-in T-SQL string functions.
  • Added String_IsNumeric to mirror the built-in T-SQL ISNUMERIC() function but that can handle more than 8000 characters and more numeric formats.
  • Added RegEx_CaptureGroup which returns just the specified captured group and not the entire capture as RegEx_Match does.
  • Added Twitter functions: GetFavorites, GetBlocks, BlockUser, UnBlockUser
  • Updated File_GetDirectoryListing to skip the “System Volume Information” folder when doing recursive as that always caused an error.
  • Added File function: GetFileInfo
  • BREAKING CHANGE L: Updated INET_GetWebPages: Added new field for ContentBinary that holds that Content data IF the data is Binary (in which case the regular Content field is NULL).  Also added new input parameter for ContentDetection to either hard-code Binary vs Text or Auto-Detect.  If using Auto-Detect, then if the ContentType starts with "text/" then the Content field is filled out and ContentBinary is NULL. [thanks to Mitch Schroeter]
  • IMPORTANT: Updated all Twitter functions to authenticate against OAuth since Basic Auth is being shut down.  This is a TEMPORARY fix which keeps the SQL# Twitter API the same for easy transition to the new authentication method.  However, Twitter is requiring a full move to OAuth by October so a new version of SQL# will be released in the next two months that will be an API change for ALL Twitter functions.  The API change will be that UserName and Password will no longer be passed in to each function but instead a ConsumerKey and ConsumerToken.  Each SQL# user who is using the Twitter functions will have to create an application on Twitter which will give you the ConsumerKey and ConsumerToken.  More details will be provided as that development occurs.  Just be aware that EVERYONE using the SQL# Twitter functions will have to upgrade to the next version when it is released!!


Version 2.10.43 and 2.10.44 (January 20th, 2010)


  • Added Twitter functions: CreateFavorite and DestroyFavorite
  • Updated Twitter functions to return UserID INT, RateLimit INT, RateLimitRemaining INT, and RateLimitReset DATETIME in the Result Set: GetFriendsTimeLine, GetMentions, GetMessages, GetPublicTimeLine, GetReplies, GetSentMessages, GetStatus, and GetUserTimeLine
  • Updated Twitter functions to return RateLimit INT, RateLimitRemaining INT, RateLimitReset DATETIME, IsVerified BIT, CreatedOn DATETIME, UTCOffset INT, and NumberOfStatuses INT in the Result Set: FollowUser, GetFollowers, GetFriends, GetUser, UnFollowUser
  • Added DB function: XOR which takes two BIT fields and does a logical Exclusive-OR on them.
  • Updated RegEx_Split: returns StartPos and EndPos fields in the Result Set.
  • Updated RegEx_Replace: “Count” input parameter now accepts -1 to mean “unlimited” replacements.
  • Updated all RegEx functions to set the “RegularExpression” input parameter to be an NVARCHAR(MAX) instead of an NVARCHAR(4000).
  • Updated String_SplitIntoFields: Added optional parameter for ColumnNames that is a comma-separated list of values that will be used to create the column names of the Procs result set.  If not set it will default to the prior behavior of using FieldN where N is the field number starting with 1.
  • Updated Date_Extract: Added DatePart’s that are found in the SQL Server built-in function DATEPART to be comprehensive: Year, Quarter, Month, Day, DayOfYear, Weekday, Week, Hour, Minute, Second, and Millisecond.  The DatePart of ISO_WEEK was previously available as ISOWEEK but is now also aliased as ISO_WEEK to match SQL Server’s DatePart name.
  • Updated SQLsharp_Setup to auto-detect if a particular Assembly has been created and if not, Setup will not attempt to create the Procs and/or Functions contained in the missing assembly.  This will allow each user to determine if they want to install the SgmlReader and/or Twitterizer and/or OS Assemblies.  Thanks to Scott Prugh for requesting optional Assembly loading.
  • BREAKING CHANGE L: Updated INET_GetWebPages: Added ResponseUri NVARCHAR(4000) to Result Set.  Also added Method NVARCHAR(10) and PostData NVARCHAR(MAX) input parameters.

 


Version 2.9.39 and 2.9.40 (November 1st, 2009)


  • Added Convert functions: HtmlToXml, UUDecode, and UUEncode
  • Added Twitter functions: DestroyDirectMessage, FollowUser, GetFollowers, GetFriends, GetMentions, GetStatus, GetUser, UnFollowUser
  • Added Date function: NthOccurrenceOfWeekday
  • Updated File_SplitIntoFields: Changed SkipFirstRow BIT into RowsToSkip INT and fixed potential memory leak.  The parameter change is non-breaking as the BIT values of 0 and 1 (representing to not skip any rows and to skip the first row respectively) directly map to the new behavior of how many rows to skip with 0 still meaning not to skip any and 1 meaning to skip 1 row which is the same result as SkipFirstRow = 1.
  • Updated Twitter functions so that StatusID is now a BIGINT instead of INT: DestroyStatus, GetFriendsTimeline, GetMessages, GetPublicTimeline, GetReplies, GetSentMessages, GetUserTimeline, SendDirectMessage, and  Update
  • Added INET functions: URIGetInfo and URIGetLeftPart
  • Updated Type_HashTable: added AddItem(@InputKey NVARCHAR(4000), @InputValue NVARCHAR(4000)) method / function.
  • Updated DB_BulkExport: Added @AppendFile BIT = 0, @RowsExported INT = -1 OUTPUT parameters.  This should be a non-breaking change since the two new parameters have defaults.  Therefore, existing implementations do not need to change.
  • Updated INET_FTPGetFile: Changed @OverwriteExistingFile BIT parameter to be @FileHandling TINYINT (2 = Incremental / Restart).  This is a non-breaking change since the old parameter BIT values of 0 and 1 directly map (i.e. implicitly convert) to the new parameter datatype of TINYINT and which cause the same behavior.  Therefore, existing implementations do not need to change.
  • BREAKING CHANGE L: Updated INET_FTPGet and INET_FTPGetBinary: Added @ContentOffset BIGINT parameter
  • BREAKING CHANGE L: Updated INET_GetWebPages: Added four new fields to the result set (IsFromCache, LastModified, StatusCode, StatusDescription) and added three new input parameters (@MaximumAutomaticRedirections, @Timeout, @MaximumResponseHeadersLength, @CustomHeaders)
  • IMPORTANT NOTE: Deprecated Twitter_DestroyMessage and replaced with Twitter_DestroyStatus.  It is just a rename as the functionality is the same.  Currently DestroyMessage points to DestroyStatus, however, please convert all references to DestroyMessage as it will be removed in the next version.


Version 2.8.32 and 2.8.33 (June 6th, 2009)


  • Minor fixes in SQLsharp_SetUp for INET_URIEncodeData and FILE_* Table-Valued Functions.
  • Minor fix in DB_ForEach and addition of Replacement Tags:
    {SQL#Schema} and {SQL#FullTableName}
  • Added ProcessName parameter to OS_ProcessKill


Version 2.8.28 and 2.8.29 / 2.8.30 and 2.8.31(May 27th and 31st, 2009)


  • Updated SQL# Installer to not cause the “file has an extremely long line” warning message when opening in Management Studio (SSMS)
  • Renamed main Assembly from [SQLsharp] to [SQL#].
  • Added two new Assemblies: [SQL#.OS] and [SQL#.Twitterizer]
  • Fixed potential memory leak in INET_GetWebPages
  • Fixed output of Table-Valued Functions to be properly streaming
  • Increased width of NVARCHAR fields in the result sets of File functions
  • Fixed RegEx functions to not error if the ExpressionToValidate is an empty string
  • Compiled RegEx patterns in Util_IsValid* functions for faster execution
  • Updated SQLsharp_Setup, SQLsharp_Uninstall, and the installation scripts to allow SQL# to be installed into a user-defined Schema and then handle being uninstalled from that Schema.  In order to install into a Schema other than “SQL#” just change the value of the @SQLsharpSchema variable.
  • Added RegExOptionsList parameter to all RegEx Functions
  • Added TrapErrorInline BIT parameter to INET_GetWebPages Function to control whether HTTP errors (e.g. 404, 500, etc.) throw an exception or get returned in the result set.  Please note that this is a Function signature change that breaks existing uses of the Function since existing calls will not have the new parameter.  Passing in NULL (or 0) as the 3rd parameter will cause the Function to work the same as it did previously.
  • Added optional @AssemblyName NVARCHAR(4000) input parameter to SQLsharp_SetSecurity so that the various SQL# Assemblies can be dealt with individually.
  • Added DB Procs: BulkCopy and ForEach
  • Added INET Function: URIEncodeData
  • Added new OS group (SQL#.OS Assembly)
  • Added OS Functions: EventLogRead, EventLogWrite, ProcessStart, ProcessGetInfo, ProcessKill, GenerateTone, MachineName, and Uptime
  • Added new Twitter group (SQL#.Twitterizer Assembly)
  • Added Twitter Functions (via Twitterizer library): Update, DestroyMessage, SendDirectMessage, GetSentMessages, GetMessages, GetFriendsTimeline, GetPublicTimeline, GetUserTimeline, and GetReplies


Version 2.7.24 and 2.7.25 (August 5th, 2008)


  • Added INet functions: FTPGetBinary, FTPGetFile, FTPPutBinary, FTPPutFile, HTMLDecode, HTMLEncode, URIDecode, and URIEncode
  • Added Date functions: Age, Extract, and Truncate
  • Updated DB function HTMLExport:
    • Translate {SQL#Column} into the column name
    • Added “EncodeHTML” option
    • Stopped single-quotes from being escaped to double single-quotes
  • Updated DB procedure DumpData: Added parameters for Disable / Re-enable ALL Constraints and/or Triggers on each table
  • Updated String function NewLine: Changed <br/> to <br /> for @EOLType = XHTML
  • Updated SQLsharp procedure SetSecurity: Fixed sending in parameter of 0 when not in a DB named [SQL#]
  • Updated SQLsharp procedure Update:
    • Fixed error that removed SQL# Schema when calling SQLsharp_Uninstall but did not re-add it
    • Added @ForceUpdate parameter; and function now checks for newer version of SQL# and will error if no newer version and @ForceUpdate is false / 0 or unset


Version 2.6.22 and 2.6.23 (May 18th, 2008)


  • Updated DB function DumpData:
    • fixed handling of BINARY, VARBINARY, and IMAGE datatypes
    • changed direct query output data-type from TEXT to NVARCHAR(MAX)
    • added optional parameter for @LinkedServer
    • added optional parameter for @FileEncoding that supports: Ascii, UTF8, Unicode, UnicodeBigEndian, and UTF32.
  • Added DB functions: BulkExport and HTMLExport
  • Opened up INET functions AddressToNumber, NumberToAddress, and IsValidIPAddress to Free Version of SQL#
  • Added Util functions: IsValidCheckRoutingNumber, and IsValidPostalCode
  • Updated SQLsharp function GrantPermissions: added optional second parameter @SQLsharpSchema
  • Added File function: CurrentEncoding
  • Updated File function WriteFile: @FileEncoding parameter now accepts: Ascii, UTF8, Unicode, UnicodeBigEndian, and UTF32
  • Updated File function WriteFileBinary: @FileEncoding parameter now accepts: Ascii, UTF8, Unicode, UnicodeBigEndian, and UTF32


Version 2.5.20 and 2.5.21 (November 18th, 2007)


  • Added File functions: GZip, GUnzip, ChangeEncoding, SplitIntoFields
  • Added INET functions: IsValidIPAddress, AddressToNumber, NumberToAddress
  • Added new Convert grouping.
  • Added Convert functions: ToBase64, FromBase64, ROT13, BinaryToHexString, HexStringToBinary
  • Added Date functions: ToUNIXTime, FromUNIXTime
  • Added String function: NthIndexOf, Cut, SplitIntoFields
  • Added Utility functions: CRC32, Hash(MD5 | SHA1 | SHA256 | SHA384 | SHA512)


Version 2.4.18 and 2.4.19 (October 14th, 2007)


  • Added File Functions: GetFileBinary, WriteFileBinary, GetDriveInfo, Move, CreateDirectory, DeleteDirectory, Encrypt, Decrypt, GetDirectoryListing, Delete, Copy, DeleteMultiple, CopyMultiple, MoveMultiple
  • Added new LookUp grouping
  • Added LookUp Functions: GetCountryInfo, GetStateInfo


Version 2.3.16 and 2.3.17 (September 10th, 2007)


  • Fixed Constructor method for all three User-Defined Types (FloatArray, HashTable, and NVarcharArray); allow for empty string (‘’) to be passed in to initialize the Type as empty.
  • Fixed Math_CompoundAmortizationSchedule: adjusted final payment calculation and minor issues with rounding


Version 2.3.14 and 2.3.15 (September 5th, 2007)


  • Added Date Functions: IsBusinessDay, FormatTimeSpan
  • Updated Date_BusinessDays: added more options for ExcludeDaysMask (Friday, Good Friday [Gregorian Calendar], Easter [Gregorian Calendar], Good Friday [Julian Calendar], Easter [Julian Calendar], Thanksgiving [CANADA], Thanksgiving [CANADA – day 2, Friday before])
  • Added Math Functions: Cosh, Sinh, Tanh
  • Added new DB grouping
  • Added DB Function: DumpData
  • Added compression to: Agg_Join


Version 2.2.12 and 2.2.13 (August 19th, 2007)


  • Added Date Functions: BusinessDays, DaysInMonth, DaysLeftInYear, FirstDayOfMonth, FullDateString, FullTimeString, IsLeapYear, LastDayOfMonth


Version 2.1.10 and 2.1.11 (July 16th, 2007)


  • Added Util Functions: IsValidCC, IsValidSSN
  • Added String Functions: Count, Newline
  • Added User-Defined Aggregate: Random
  • Added compression to: Agg_Median, Type_FloatArray, Type_NVarcharArray, Type_HashTable


Version 2.0.8 and 2.0.9 (March 18th, 2007)


  • Enhanced Installation script
  • Added SQL# Schema
  • Fixed result column names in Util_Generate* functions and RegEx_* functions
  • Enhanced error-handling and success output of SQLsharp_SetSecurity
  • Added Optimizer Hints (IsDeterministic and IsPrecise) to all functions
  • Removed UseBinaryMode option from INET_FTPGet and INET_FTPPut
  • Added File functions: GetFile, GetRandomFileName, GetTempPath, PathExists, WriteFile
  • Added User-Defined Aggregates: GeometricAvg, Join, Median, RootMeanSqr
  • Added User-Defined Types: DoubleArray, HashTable, NVarcharArray


Version 1.5.6 and 1.5.7 (February, 16th, 2007)


  • Fixed installation / setup so that it completes successfully ;-)
  • Changed prefix for Miscellaneous functions to be Util_ instead of Phnx_
  • Added Math_CompoundAmortizationSchedule (BETA), Util_GZip, Util_GUnzip, Util_Deflate, Util_Inflate


Version 1.1.5 (October 20th, 2006)


  • Paid-for Version
  • Includes all functions
  • Same as Version 1.1.4 except it includes all INET functions and SQLsharp_Update


Version 1.1.4 (October 20th, 2006)


  • Free Version
  • Removed: all INET functions and SQLsharp_Update
  • Added: Math_RandomRange
  • Changed:
    • Bug in Phnx_ToWords returned Negative Zero for -1
    • Added Lower and Upper bounds checking in Phnx_ToWords
    • Changed return datatype in Math_IsPrime to BIT from INT
    • Added StepTypes of Quarter and Week to Phnx_GenerateDateTimes and Phnx_GenerateDateTimeRange
    • Added abbreviations for StepTypes as paralleled in Books Online under DATEADD and DATEDIFF functions (ex: year = yyyy, yy)


Version 1.1.3 (not released)


  • Added: INET_FTPDo, INET_FTPGet (BETA), INET_FTPPut (BETA), INET_GetIPAddress, INET_GetHostName


Version 1.0.2 (June 25th, 2006 – Initial Release)


  • String_Combine, String_Contains, String_EndsWith, String_Equals, String_IndexOf, String_InitCap, String_LastIndexOf, String_PadLeft, String_PadRight, String_Split, String_StartsWith, String_Trim, String_WordWrap
  • RegEx_IsMatch, RegEx_Match, RegEx_Matches, RegEx_Replace, RegEx_Split
  • Math_Constants (30 physics constants), Math_Convert (22 measurement conversions), Math_Factorial, Math_IsPrime
  • INET_GetWebPages, INET_Ping, INET_PingTime
  • Phnx_GenerateDateRange, Phnx_GenerateDates, Phnx_GenerateFloatRange, Phnx_GenerateFloats, Phnx_GenerateIntRange, Phnx_GenerateInts, Phnx_ToWords
  • SQLsharp_GrantPermissions, SQLsharp_Help,  SQLsharp_IsUpdateAvailable, SQLsharp_SetSecurity, SQLsharp_Setup,  SQLsharp_Uninstall, SQLsharp_Update, SQLsharp_Version, SQLsharp_WebSite

SQL CLR Library , CLR Routines , CLR Library , SQL Server CLR , Bulk Export , Regular Expressions , HTML Export , Generate Insert Statements 2012-5-19 0-48