Neither was a good solution, but that is all we had. In comes SQL Server 2005 with its CLR integration to alleviate these problems. By integrating the CLR, SQL Server 2005 allows you to deploy C# ...

T-SQL isn't particularly well suited to advanced string manipulation. I have found that small CLR functions that perform string manipulation and substring extraction perform very well in SQL Server.

A comparison of Transact-SQL and languages supported by Microsoft's Common Language Runtime.

The heart of the Microsoft integration strategy lies in the integration of the companys CLR (Common Language Runtime) into the SQL Server database engine, known as SQL CLR. But it doesnt stop ...

To some extent, CLR is also SQL Server-independent. Although Microsoft’s .NET vision pre-dates the arrival of SQL Server 2000, the software giant didn’t deliver the first release of its .NET framework ...

T-SQL isn't particularly well suited to advanced string manipulation. I have found that small CLR functions that perform string manipulation and substring extraction perform very well in SQL Server.