Geek Answers Handbook

SQLCLR community extensions or shared library

I just finished writing the Regex and tvf replace and match function for SQLCLR for the fifth time, I sat and wondered if there was a set of common community extensions for SQLCLR for the most common things you want in the database, but never provided.

Powershell, for example, has an excellent set of community extensions that cover many additional features not included in the field. I would not use Powershell without it.

I thought the SQLCLR had something similar. I am looking for things like:

  • Regular Expression Support (isMatch, Replace, Match)
  • Base64 Encoding / Decoding Support
  • Formatting strings (Datetimes, byte arrays, floats and decimal numbers, etc.)
  • Hashing, encryption with arbitrary algorithms (I know that SQL 2k5, 2k8 supports some basic things, but not SHA2? What is connected with this?)
  • General additional aggregations; OR bit and bit, string cat (String.Join)
  • Compression / decompression

Does anyone know of a library that has the usual ordinary functions like these that we all write over and over?

+5
source share
2 answers

Peter take a look at SQL #, which is a SQLCLR assembly created by Solomon Rutchi, which has two versions: a free version and a paid version. You will find that the free edition includes several items mentioned above.

http://www.sqlsharp.com/

+3
source

SplitString() . , SqlClrContrib? , ?

0

More articles:


All Articles