Where to find ready to use CLR dlls for SQL Server
There are a lot of standard tasks开发者_JAVA百科, which are not part of T-SQL, e.g.
- string concatenate aggregate function
- regex string compare
are there location where I can download recompiled dlls and get with installation instructions.
I'm not interested in compiling those dlls myself.
Edit:
The answers motivated me to change my attitude concerning compiling the CLR dlls myself.
Sorry, you'd generally have to compile yourself because of .net versions, or 32/64 bit etc.
A quick google came up with this.
The SqlClr Library is a collection of CLR routines written in C# for MS Sql Server 2005 database programmers. This project augments TSQL (aka T-SQL or Transact SQL) functionality. Providing the database programmer with more tools.
Though it doesn't have any released files.
There is also this site, which only has a single RegEx library.
Here is another CodePlex project that actually has some files - mostly string manipulation and formatting from a quick glance:
The Fotia SQLCLR library contains indispensable SQL Server 2008 user-defined functions and aggregates written in C#.
精彩评论