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#.