Writing a CLR Stored Procedure on SQL Server

This article shows how to create an SQL CLR Stored Procedure step by step. Also, the example it uses is very useful, since it shows you how to load a file list from the file system within SQL.