In one of my recent projects I learnt how to use CLR stored procedures. So what exactly are CLR stored procedures? Well they allow you to run code (C#) inside SQL Server 2005. So instead of creating stored procedures or UDF (User Defined Functions) with SQL code you use C# code to achieve this. There [...]