SQL# (SQLsharp) - Expanding the capabilities of T-SQL via SQLCLR (Features)

SQL #

Expanding the
capabilities of T-SQL

Home Features Benefits F.A.Q. Contact Us
Full Version Free Version Documentation

SQL CLR Library , SQLCLR , CLR Routines , CLR Library , SQL Server CLR , Bulk Export , Regular Expressions , HTML Export , Generate Insert Statements , Median , Automation , RegEx

⸦ Features ⸧

Category	In Free and Full versions	Additional in Full version only
Convert	Base2ToBase10 Base10ToBase2 BinarySidToSddl BinaryToHexString DateTimeToMSIntDate FromBase64 HexStringToBinary HtmlToXml MSIntDateToDateTime ROT13 SddlSidToBinary ToBase64 UUDecode UUEncode	( none )
Date	Age BusinessDays DaysInMonth DaysInMonthFromDateTime DaysLeftInYear Extract FirstDayOfMonth Format FormatOffset FormatTimeSpan FromUNIXTime FullDateString FullTimeString GetDateTimeFromIntVals GetIntDate GetIntTime IsBusinessDay IsLeapYear LastDayOfMonth NewDateTime NthOccurrenceOfWeekday ToUNIXTime Truncate	BusinessDaysAdd DaysLeftInMonth FullDateTimeString IsDaylightSavingTime ToLocalTime ToUniversalTime
DB	BulkCopy WaitForDelay	BulkExport CreateOrAlterQueryInfoTables CurrentSQLStatement DescribeResultSets DeserializeResults DumpData ForEach GetQueryInfo HTMLExport NewID SerializeResults SerializeResultsInChunks ThrowException TryCatch
File (File System)	( none )	ChangeEncoding CheckLongPathSupportRequirements Copy CopyMultiple CreateDirectory CreateTempFile CurrentEncoding Decrypt Delete DeleteDirectory DeleteMultiple Encrypt FileExists GetCRC32 GetDirectoryListing GetDirectoryName GetDriveInfo GetFile GetFileBinary GetFileInfo GetFileName GetFullPath GetHashBinary GetLineCount GetRandomFileName GetRootDirectory GetTempPath GUnzip GZip Move MoveDirectory MoveMultiple PathExists SplitIntoFields Touch WriteFile WriteFileBinary
INET (Network)	AddressToNumber HTMLDecode HTMLEncode IsValidIPAddress NumberToAddress URIDecode URIEncode URIEncodeData URIGetInfo URIGetLeftPart	DownloadFile FTPDo FTPGet FTPGetBinary FTPGetFile FTPPut FTPPutBinary FTPPutFile GetConnectionLimitForURI GetCurrentConnectionCountForURI GetHostName GetIPAddress GetIPAddressList GetWebPages Ping PingTime SetConnectionLimitForURI SplitIntoFields URIDecodePlus
JSON	( none )	JSONtoXML XMLtoJSON
LookUp	GetCountryInfo GetStateInfo	( none )
Math	CompoundAmortizationSchedule CompoundAmortizationSchedule2 Constant Convert Cosh CubeRoot Factorial FormatDecimal IsPrime RandomRange RoundToEvenDecimal RoundToEvenFloat Sinh Tanh Truncate	BitwiseLeftShift BitwiseRightShift FormatFloat FormatInteger IEEERemainder NthRoot
OS (Operating System)	EventLogRead EventLogWrite GenerateTone MachineName ServiceAccount Uptime	GetEnvironmentVariable GetEnvironmentVariables GetSystemEnvironmentVariable GetSystemEnvironmentVariables GetUserEnvironmentVariable GetUserEnvironmentVariables IsBinarySidAValidWindowsAccount IsSddlSidAValidWindowsAccount PerfCounterAddData PerfCounterCreateCategory PerfCounterGetSample PerfCounterGetValue ProcessGetInfo ProcessKill ProcessStart SetEnvironmentVariable SetUserEnvironmentVariable StartTime TranslateSddlSidToName
RegEx (Regular Expressions)	CaptureGroup (and 4k ) CaptureGroupCapture (and 4k ) Escape (and 4k ) GetCacheSize Index (and 4k ) IsMatch (and 4k ) Match (and 4k ) Matches (and 4k ) MatchLength (and 4k ) MatchSimple (and 4k ) Replace (and 4k ) ReplaceIfMatched (and 4k ) Split (and 4k ) Unescape (and 4k **)	CaptureGroupCaptures (and 4k ) CaptureGroups (and 4k ) SetCacheSize
Running Total	( none )	Add CacheSize ClearCache Get
SQLsharp (Internal)	DisplayEULA GrantPermissions Help InstanceSetup IsUpdateAvailable ManualMetadata ManualRevisionNumber SaveManualToDisk SetSecurity Setup Uninstall UnloadAppDomain Version WebSite	Download
String	Contains Count Cut EndsWith Equals IndexOf InitCap IsNumeric Join LastIndexOf (and 4k ) Newline NthIndexOf PadLeft PadRight Replace Split (and 4k ) SplitInts (and 4k ) StartsWith ToLowerInvariant (and 4k ) ToTitleCase (and 4k ) ToUpperInvariant (and 4k ) Trim (and 4k ) TryParseToDateTime TryParseToDecimal TryParseToInt Unescape (and 4k ) WordWrap	CompareSplitValues CompareWithDynamicCollation DamerauLevenshteinDistance DamerauLevenshteinDistancePlus FixedWidthIndex FixedWidthSplit LevenshteinDistance LevenshteinDistancePlus PadBoth (and 4k ) RemoveDiacritics (and 4k ) SplitIntoGuids (and 4k ) SplitIntoIntegers (and 4k ) SplitKeyValuePairs (and 4k ) SplitResultIntoFields TrimChars (and 4k ) TrimEnd (and 4k ) TrimStart (and 4k )
Sys (Cross-DB Views)	( none )	AllAssemblies AssemblyName IndexName LockResource Objects
Twitter ( Direct Message functions no longer work. Hope to fix at least "Send" in upcoming release. )	BlockUser CreateFavorite DestroyDirectMessage DestroyFavorite DestroyStatus FollowUser GetBlocks GetFavorites GetFollowers GetFriends GetHomeTimeline GetMentions GetMessages GetRetweetedBy GetRetweets GetRetweetsOfMe GetSentMessages GetStatus GetUser GetUserByScreenName GetUserTimeline Retweet SendDirectMessage UnBlockUser UnFollowUser Update xAuth	GetApiResponseJSON GetApiResponseXML GetBlockedUserIDs GetFollowerUserIDs GetFriendUserIDs GetMutedUserIDs GetMutes GetStatusesByStatusIDs GetUsersByScreenNames GetUsersByUserIDs MuteUser SearchTweets UnMuteUser UnRetweet
Util (Utility)	CRC32 Deflate GenerateDateTimeRange GenerateDateTimes GenerateFloatRange GenerateFloats GenerateIntRange GenerateInts GetTotalMemory GUnzip GZip Hash HashBinary Inflate IsValidCC IsValidCCNumber IsValidCheckRoutingNumber IsValidConvert IsValidPostalCode IsValidSSN ToWords	GarbageCollect GetBase2Bits GetCreditCardInfo GetCreditCardType Paginate Print UnBitMask
XML	( none )	EscapeContent SaveToFile Transform UnescapeContent
User-Defined Aggregates (Agg)	GeometricAvg Join JoinDelim Median Random RootMeanSqr	BitwiseAND BitwiseOR BitwiseXOR HarmonicMean JoinPlus
User-Defined Types (Type)	FloatArray HashTable NVarcharArray	( none )
	184 objects (plus 21 "4k" versions **)	163 objects (plus 10 "4k" versions **)
	347 total objects (plus 31 total "4k" versions **)

** "4k" versions: Quite a few of the String and RegEx functions that have NVARCHAR(MAX) input parameters, and/or output parameters, and/or return types have a second T-SQL wrapper object, pointing to the same .NET method, but that does not use any MAX type, instead using NVARCHAR(4000). The problem with NVARCHAR(MAX) is that if there is even one of them in the object's signature, then there is a noticable performance hit. If the function you are using has a "4k" version and the parameters, return type, or result set fields are guaranteed to never hold more than 4000 characters (or more accurately: 8000 bytes worth of characters since Supplementary Characters are 4 bytes each), then use the "4k" version as it will perform better.

What can SQL# do?

SQL# gives you the easiest access to the power of the CLR!
-- Over 340 Procs and Functions, 11 User-Defined Aggregates, 3 User-Defined Types, and more being added!
SQL# installs easily and in moments!
-- download one small install sql script, execute it, and enjoy the power of the CLR!
SQL# is backed up and restored with the database along with all other objects and data!
-- no need to worry about separate DLLs as with COM Extended Stored Procedures
SQL# has the PDF manual embedded in it!
-- if you ever lose the documention and aren't connected to the Internet, the worst off you are is one procedure call away from extracting the manual to disk!
SQL# saves countless hours learning CLR and .NET, not to mention the time spent testing and fixing (repreat several times)!
-- time is money and you have work to do so why stop and learn yet another language, especially when you might need to purchase additional software just to compile a basic function!
SQL# lets you focus on SQL programming without sacrificing the power of the CLR!
-- again, there is only so much time in the day so do you want to spend it NOT being productive?