How to load .NET code in SQL SERVER 2005

First of all write managed code and compile it to DLL/Assembly.Now we can load the assembly in SQL SERVER.Here i have given a example of SQL SERVER. CREATE ASSEMBLY percode FROM 'c:/percode.dll'