One of the C # SQL CLR

The CLR is a public runtime, and this article simply explains the process of writing SQL StoredProcedures in C #.

Steps

2.

3.

7. Open Settings

8.

Attention
Delete method: Note When deleting assembly, be sure to first remove all the things that refer to this Assembly
drop proc Queryqueuesp
Go
Drop Assembly Queryqueue

Finally, let's talk about the deployment of CLR stored procedures:
The Create proc Stored procedure name is the assembly name in the EXTERNAL name database. The assembly name (class name) in the assembly. The name of the program method.
Note that if you have a namespace in your program, write it like this:
Create proc Stored procedure name as EXTERNAL name in database assembly. " The program namespace. Assembly name in the assembly. The program method name.
Demo CREATE proc ssbsp as EXTERNAL NAME [Ssbmonitor]. " AuthReceiver.SSBMonitor.Processor ". [Go]

One of the C # SQL CLR