C # One of SQL CLR,

C # One of SQL CLR,

When CLR is a public runtime, this article will briefly explain the process of compiling SQL StoredProcedures in c.

[STEP]

2.

3.

7. Open settings

8.

 

Note:
Delete method: When deleting an Assembly, you must first delete all the items that reference this Assembly.
Drop proc QueryQueueSP
Go
Drop assembly QueryQueue

Finally, deploy the CLR Stored Procedure:
Create proc stored procedure NAME as external name Assembly NAME in the database. Assembly NAME in the Assembly set (Class NAME). Program Method NAME.
NOTE: If your program has a namespace, write it as follows:
Create proc stored procedure NAME as external name Assembly NAME in the database. "program namespace. Assembly NAME in the Assembly set". Program Method NAME.
Demo create proc SSBSp as external name [SSBMonitor]. "AuthReceiver. SSBMonitor. Processor". [Go]