What is a CLR Stored Procedure?
The CLR Stored Procedures were introduced with SQL Server 2005. They allow writing of stored procedures, triggers, functions, user defined types using .NET languages such as VB.NET and C#.