You can use CLR to author a number of database objects. Follow a canonical example that explains the main steps involved in using and creating a CLR object inside SQL Server 2005.
This story continues at http://www.databasejournal.com/news/article.php/3548931
