SQLCLR 社区扩展或公共库
刚刚第五次为 SQLCLR 编写正则表达式替换和匹配函数以及 tvf 后，我坐下来思考是否有一组常见的 SQLCLR 社区扩展，可以满足您在数据库中想要但从未提供的最常见的功能。
例如，Powershell 拥有一组出色的社区扩展，涵盖了盒子中未包含的大量附加功能。 没有它我就不会使用 Powershell。
我想也许 SQLCLR 有类似的东西。 我正在寻找类似的东西：
- 正则表达式支持（isMatch、Replace、Match）
- Base64 编码/解码支持
- 字符串格式（日期时间、字节数组、整数浮点数和小数等）
- 散列、使用任意算法加密（我知道 SQL 2k5、 2k8 支持一些基本功能，但不支持 SHA2？）
- 常见的附加聚合； OR 位、AND 位、cat 字符串 (String.Join)
- 压缩/解压缩
有谁知道有一个库具有像我们一遍又一遍地编写的常见例程功能吗？
Having just finished writing a Regex replacement and match function and tvf for SQLCLR for the fifth time, I sat and pondered whether there was a set of common community extensions for SQLCLR for the most common things you want in a database but are never provided.
Powershell for example has an excellent set of community extensions that cover a plethora of additional functionality not included in the box. I wouldn't use Powershell without it.
I thought maybe SQLCLR had something similar. I'm looking for things like:
- Regular expression support (isMatch, Replace, Match)
- Base64 encode/decode support
- String formatting (Datetimes, byte arrays, ints floats and decimals, etc)
- Hashing, encryption with arbitrary algorithms (I know SQL 2k5, 2k8 support some basic stuff but no SHA2? What is up with that?)
- Common additional aggregations; OR bits, AND bits, cat strings (String.Join)
- Compression/decompression
Does anyone know of a library that has common routine functionality like this that we all write over and over again?
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（2）
Peter 看一下 SQL#，它是由 Solomon Rutzky 创建的 SQLCLR 程序集，有两个版本：免费版和付费版。 您会发现免费版包含您上面提到的许多项目。
http://www.sqlsharp.com/
Peter take a look at SQL# which is a SQLCLR Assembly created by Solomon Rutzky that has two versions, a FREE edition and a pay version. You will find that the FREE edition has a number of the items that you have mentioned above included.
http://www.sqlsharp.com/
SplitString() 以及许多其他内容都可以添加。 也许我们创建一个 SqlClrContrib 站点？ 人们可以在哪里将他们的想法发布到开源项目中，我们可以添加这样的功能？
SplitString(), and many others could be added. Perhaps we create a SqlClrContrib site? Where people can post their ideas to an open source project and we can add such functions?