SQL Server stored procedure calls a DLL file written in C #

Create a new C # class library, compile.

Add Reference

using Microsoft.SqlServer.Server;

Method

[SqlFunction]  Public Static int Generatetxt () {   ...}

Modify Database Configuration

---'clr enabled'1; reconfigure;

Registering assemblies based on DLL path

--'E:\Study\VS2010\PingAnCustomerInfoInterface\PingAnCustomerInfoInterface\bin\Debug\ PingAnCustomerInfoInterface.dll'

Call

IF EXISTS (SELECT  * from    sysobjects            WHERE   = object_id ('ontimework  ')     BEGIN         DROP PROCEDURE ontimework    END gocreate PROCEDURE Ontimeworkas EXTERNAL NAME     

Notice the function call method: [AssemblyName]. [Assemblyname.classname]. [FunctionName]

SQL Server stored procedure calls a DLL file written in C #