What is CLR?

CLR (Common Language Runtime)

Common Language Runtime (CLR) in SQL Server is a new enhancement in Microsoft SQL Server database featured with SQL Server 2005 and later products.

CLR introduces .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 stored procedures (SPs), user-defined functions (UDFs), user-defined types (UDTs), triggers using any of the .NET Framework programming languages.