News

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 ...
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: 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 ...
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 ...
CLR functions that perform string manipulation and substring extraction perform very well in SQL Server.