C# clr 存储过程例子(完整从:编译到配置到存储过程的安装部署到使用)
//代码
using System;
using System.Data;
using Microsoft.SqlServer.Server;
using System.Data.SqlTypes;
public class HelloWorldProc
{
[Microsoft.SqlServer.Server.SqlProcedure]
public static void HelloWorld()
{
SqlContext.Pipe.Send("Hello world!/n");
}
}
//编译
csc /target:library helloworld.cs
//建立部署
CREATE ASSEMBLY helloworld from 'D:/StoreProcedure/helloworld.dll' WITH PERMISSION_SET = SAFE
CREATE PROCEDURE hello
AS
EXTERNAL NAME helloworld.HelloWorldProc.test
//权限配置
EXEC sp_configure 'clr enabled', '1';
RECONFIGURE;
//使用
exec hello