For anyone else confused, the SQL CLR is a programming platform inside SQL Server that allows you to write your own assemblies in any .NET language to call from t-sQL and work with data.

http://msdn.microsoft.com/en-us/library/ms189566%28SQL.90%29.aspx