Using SQL/CLR integration

Here is a good example of how you can use .Net language and integrate it into SQL.

e.g. run a piece of c sharp code in a stored procedure

SQL CLR Stored Procedure using Visual Studio 2010