Using the CLR Function Once deployed to the SQL Server, the CLR function appears in the Programmability, Functions, Scalar-valued Functions folder of the database, much like a T-SQL user-defined ...

CLR functions that perform string manipulation and substring extraction perform very well in SQL Server.

SQL Server 2005 will integrate with the CLR, so you can deploy C# or VB.NET code within the SQL Server process. In this first of a two-part series, Shawn Wildermuth explains what's involved, and ...

CLR: Best for code that’s computation- or logic-intensive. A better option than “extended stored procedures,” which Microsoft offered in earlier SQL Server releases for creating server-side ...

In This Section SqlContext Object This class provides access to the other extensions by abstracting the context of a caller of a SQL Server routine that executes managed code in-process. SqlPipe ...

SQL Server includes .Net&'s CLR so assemblies can execute on the same server. By managing the execution of multiple applications in process outside and inside the CLR, SQL Server can optimize both ...

So I'm faced with a task that involves compressing data stored in an SQL Server 2005 database.The data is mainly pdf documents, but tons of other documents are stored there as well. Most of them ...

I've googled for this on several occasions, but not really found any good information. I have a SQL 2005 CLR procedure that builds dynamic (parameterized) SQL. I basically have a main statement ...