What are steps to load a .NET code in SQL SERVER 2005

Write the managed code and compile it to a DLL/Assembly.After the DLL is compiled using the “CREATE ASSEMBLY” command you can load the assemby into SQL SERVER. Below is the create command which is loading “mycode.dll” into SQL SERVER using the “CREATE ASSEMBLY” commandSyntax

CREATE ASSEMBLY AssemblyName FROM ‘C:/MyAssmbly.dll’