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