What is CLR (Common Language Runtime) in SQL Server for SQL Programmers?
Common Language Runtime (CLR) in SQL Server is a new enhancement in Microsoft SQL Server database featured with SQL Server 2005 and later products.
SQL CLR introduces Microsoft .NET Framework development and
.NET Framework features in SQL Server objects for database developers.
Microsoft SQL Server 2005 and SQL Server 2008 (Katmai) developers can write or build sql stored procedures (SPs), user-defined functions (UDFs), user-defined types (UDTs), and sql triggers using any of the .NET Framework programming languages.
For a more specific example on SQL Server CLR, T-SQL programmers can refer to sql tutorial titled SQL Server CLR Split String Function.