SQL Server: Using .NET assemblies (SQLCLR)

SQLCLR is a technology for hosting of the .NET CLR engine inside SQL Server. Adding an assembly can be a lifesaver sometimes, since the limitations of coding in TSQL stored procedures, triggers or functions are a lot and profound.

As a quick guide, follow these steps:
1. Create a new class library using Studio
New Class Library Project

2. Add the following code

3. After building the assembly, place the dll somewhere that SQL Server can read it and try the following: