To create .NET database objects, you write managed code in any one of the .NET languages (VB, C#, or Managed C++), and compile it into a .NET DLL.
After the coding for the CLR object has been completed, you can use the T-SQL to create a SQL Server assembly
CREATE ASSEMBLY SqlDbCLRDemo FROM 'C:\SqlCLRDemo.dll' WITH PERMISSION_SET = SAFE GO
Once the SQL Server assembly is created, you can then use T-SQL to create CLR database objects.
CREATE PROCEDURE usp_HelloWorld AS EXTERNAL NAME SqlCLRDemo.StoredProcedures.HelloWorld GO
CREATE PROCEDURE statement creates a stored procedure usp_HelloWorld that uses the
EXTERNAL NAME clause to point to the assembly that you created earlier.