SQL CLR Library , SQLCLR , CLR Routines , CLR Library , SQL Server CLR , Bulk Export , Regular Expressions , HTML Export , Generate Insert Statements , Median , Automation , RegEx 2026-5-11 2-39
SQL# / SQLsharp                   SQL #         Expanding the
capabilities of T-SQL
       Home       Features       Benefits       F.A.Q.       Contact Us 
     Full Version       Free Version       Documentation 
❗❗ Version 4.0 Announcement ❗❗
  SQL CLR Library , SQLCLR , CLR Routines , CLR Library , SQL Server CLR , Bulk Export , Regular Expressions , HTML Export , Generate Insert Statements , Median , Automation , RegEx
Category In Free and Full versions Additional in Full version only
Convert
  1. Base2ToBase10
  2. Base10ToBase2
  3. BinarySidToSddl
  4. BinaryToHexString
  5. DateTimeToMSIntDate
  6. FromBase64
  7. HexStringToBinary
  8. HtmlToXml
  9. MSIntDateToDateTime
  10. ROT13
  11. SddlSidToBinary
  12. ToBase64
  13. UUDecode
  14. UUEncode
( none )
Date
  1. Age
  2. BusinessDays
  3. DaysInMonth
  4. DaysInMonthFromDateTime
  5. DaysLeftInYear
  6. Extract
  7. FirstDayOfMonth
  8. Format
  9. FormatOffset
  10. FormatTimeSpan
  11. FromUNIXTime
  12. FullDateString
  13. FullTimeString
  14. GetDateTimeFromIntVals
  15. GetIntDate
  16. GetIntTime
  17. IsBusinessDay
  18. IsLeapYear
  19. LastDayOfMonth
  20. NewDateTime
  21. NthOccurrenceOfWeekday
  22. ToUNIXTime
  23. Truncate
  1. BusinessDaysAdd
  2. DaysLeftInMonth
  3. FullDateTimeString
  4. IsDaylightSavingTime
  5. ToLocalTime
  6. ToUniversalTime
DB
  1. BulkCopy
  2. WaitForDelay
  1. BulkExport
  2. CreateOrAlterQueryInfoTables
  3. CurrentSQLStatement
  4. DescribeResultSets
  5. DeserializeResults
  6. DumpData
  7. ForEach
  8. GetQueryInfo
  9. HTMLExport
  10. NewID
  11. SerializeResults
  12. SerializeResultsInChunks
  13. ThrowException
  14. TryCatch
File
(File System)
( none )
  1. ChangeEncoding
  2. CheckLongPathSupportRequirements
  3. Copy
  4. CopyMultiple
  5. CreateDirectory
  6. CreateTempFile
  7. CurrentEncoding
  8. Decrypt
  9. Delete
  10. DeleteDirectory
  11. DeleteMultiple
  12. Encrypt
  13. FileExists
  14. GetCRC32
  15. GetDirectoryListing
  16. GetDirectoryName
  17. GetDriveInfo
  18. GetFile
  19. GetFileBinary
  20. GetFileInfo
  21. GetFileName
  22. GetFullPath
  23. GetHashBinary
  24. GetLineCount
  25. GetRandomFileName
  26. GetRootDirectory
  27. GetTempPath
  28. GUnzip
  29. GZip
  30. Move
  31. MoveDirectory
  32. MoveMultiple
  33. PathExists
  34. SplitIntoFields
  35. Touch
  36. WriteFile
  37. WriteFileBinary
INET
(Network)
  1. AddressToNumber
  2. HTMLDecode
  3. HTMLEncode
  4. IsValidIPAddress
  5. NumberToAddress
  6. URIDecode
  7. URIEncode
  8. URIEncodeData
  9. URIGetInfo
  10. URIGetLeftPart
  1. DownloadFile
  2. FTPDo
  3. FTPGet
  4. FTPGetBinary
  5. FTPGetFile
  6. FTPPut
  7. FTPPutBinary
  8. FTPPutFile
  9. GetConnectionLimitForURI
  10. GetCurrentConnectionCountForURI
  11. GetHostName
  12. GetIPAddress
  13. GetIPAddressList
  14. GetWebPages
  15. Ping
  16. PingTime
  17. SetConnectionLimitForURI
  18. SplitIntoFields
  19. URIDecodePlus
JSON ( none )
  1. JSONtoXML
  2. XMLtoJSON
LookUp
  1. GetCountryInfo
  2. GetStateInfo
( none )
Math
  1. CompoundAmortizationSchedule
  2. CompoundAmortizationSchedule2
  3. Constant
  4. Convert
  5. Cosh
  6. CubeRoot
  7. Factorial
  8. FormatDecimal
  9. IsPrime
  10. RandomRange
  11. RoundToEvenDecimal
  12. RoundToEvenFloat
  13. Sinh
  14. Tanh
  15. Truncate
  1. BitwiseLeftShift
  2. BitwiseRightShift
  3. FormatFloat
  4. FormatInteger
  5. IEEERemainder
  6. NthRoot
OS
(Operating
System)
  1. EventLogRead
  2. EventLogWrite
  3. GenerateTone
  4. MachineName
  5. ServiceAccount
  6. Uptime
  1. GetEnvironmentVariable
  2. GetEnvironmentVariables
  3. GetSystemEnvironmentVariable
  4. GetSystemEnvironmentVariables
  5. GetUserEnvironmentVariable
  6. GetUserEnvironmentVariables
  7. IsBinarySidAValidWindowsAccount
  8. IsSddlSidAValidWindowsAccount
  9. PerfCounterAddData
  10. PerfCounterCreateCategory
  11. PerfCounterGetSample
  12. PerfCounterGetValue
  13. ProcessGetInfo
  14. ProcessKill
  15. ProcessStart
  16. SetEnvironmentVariable
  17. SetUserEnvironmentVariable
  18. StartTime
  19. TranslateSddlSidToName
RegEx
(Regular
Expressions)
  1. CaptureGroup (and 4k **)
  2. CaptureGroupCapture (and 4k **)
  3. Escape (and 4k **)
  4. GetCacheSize
  5. Index (and 4k **)
  6. IsMatch (and 4k **)
  7. Match (and 4k **)
  8. Matches (and 4k **)
  9. MatchLength (and 4k **)
  10. MatchSimple (and 4k **)
  11. Replace (and 4k **)
  12. ReplaceIfMatched (and 4k **)
  13. Split (and 4k **)
  14. Unescape (and 4k **)
  1. CaptureGroupCaptures (and 4k **)
  2. CaptureGroups (and 4k **)
  3. SetCacheSize
Running Total ( none )
  1. Add
  2. CacheSize
  3. ClearCache
  4. Get
SQLsharp
(Internal)
  1. DisplayEULA
  2. GrantPermissions
  3. Help
  4. InstanceSetup
  5. IsUpdateAvailable
  6. ManualMetadata
  7. ManualRevisionNumber
  8. SaveManualToDisk
  9. SetSecurity
  10. Setup
  11. Uninstall
  12. UnloadAppDomain
  13. Version
  14. WebSite
  1. Download
String
  1. Contains
  2. Count
  3. Cut
  4. EndsWith
  5. Equals
  6. IndexOf
  7. InitCap
  8. IsNumeric
  9. Join
  10. LastIndexOf (and 4k **)
  11. Newline
  12. NthIndexOf
  13. PadLeft
  14. PadRight
  15. Replace
  16. Split (and 4k **)
  17. SplitInts (and 4k **)
  18. StartsWith
  19. ToLowerInvariant (and 4k **)
  20. ToTitleCase (and 4k **)
  21. ToUpperInvariant (and 4k **)
  22. Trim (and 4k **)
  23. TryParseToDateTime
  24. TryParseToDecimal
  25. TryParseToInt
  26. Unescape (and 4k **)
  27. WordWrap
  1. CompareSplitValues
  2. CompareWithDynamicCollation
  3. DamerauLevenshteinDistance
  4. DamerauLevenshteinDistancePlus
  5. FixedWidthIndex
  6. FixedWidthSplit
  7. LevenshteinDistance
  8. LevenshteinDistancePlus
  9. PadBoth (and 4k **)
  10. RemoveDiacritics (and 4k **)
  11. SplitIntoGuids (and 4k **)
  12. SplitIntoIntegers (and 4k **)
  13. SplitKeyValuePairs (and 4k **)
  14. SplitResultIntoFields
  15. TrimChars (and 4k **)
  16. TrimEnd (and 4k **)
  17. TrimStart (and 4k **)
Sys
(Cross-DB
Views)
( none )
  1. AllAssemblies