SQL CLR provides a method for extending the capabilities of SQL Server via the Microsoft.Net platform and the common-language-runtime.
SQL CLR allows you to use C# to create natively compiled, highly customized code patterns that may not be supported or easily implementable directly through T-SQL, such as user-defined aggregates and user-defined types.