SQL Server support .NET Integration, where we can call a code which which was developed outside the SQL Server like dll , fuctions.
Steps for building a CLR stored procedure in SQL Server 2008
1. Enabling CLR integration in SQL Server 2008
2. Creating a CLR stored procedure Assembly
3. Deploying the Assembly in SQL Server 2008
4. Creating & executing the CLR stored procedure in SQL Server 2008
For detailed step by step information, visit the following article.
http://sqlserver-training.com/can-we-...