SQLCLR
1、启用SQLCLR
EXEC sp_configure 'clr enabled',1
RECONFIGURE WITH OVERRIDE
GO
2、编译代码（改到cs文件目录下CD:)
csc /t:library HiCsWorld.cs
3、安装C#程序集
CREATE ASSEMBLY CsProcs FROM 'D:\myDocuments\VS05_Programe\CS\Chapter09\HiCsWorld.dll'
WITH PERMISSION_SET=SAFE
GO
4、修改执行权限
use master
alter database northwind set trustworthy on
go
5、注册存储过程
CREATE PROCEDURE SayCsHi
AS EXTERNAL NAME CsProcs.[CsTestNamespace.CsTestClass].SayHi
go
6、刷新程序集
ALTER ASSEMBLY CsProcs FROM 'D:\myDocuments\VS05_Programe\CS\Chapter09\HiCsWorld.dll'
GO
7、查看已安装程序集及其权限
SELECT * FROM sys.assemblies
8、注册带参数的存储过程
CREATE PROCEDURE GetGreeting
@name nvarchar(50),
@greeting nvarchar(100)
AS EXTERNAL NAME CsProcs.[CsTestNamespace.CsTestClass].GetGreeting
go
9、执行带参数的存储过程
DECLARE @result nvarchar(100)
EXEC GetCsGreeting 'SamYang',@result output
PRINT @result
EXEC sp_configure 'clr enabled',1
RECONFIGURE WITH OVERRIDE
GO
2、编译代码（改到cs文件目录下CD:)
csc /t:library HiCsWorld.cs
3、安装C#程序集
CREATE ASSEMBLY CsProcs FROM 'D:\myDocuments\VS05_Programe\CS\Chapter09\HiCsWorld.dll'
WITH PERMISSION_SET=SAFE
GO
4、修改执行权限
use master
alter database northwind set trustworthy on
go
5、注册存储过程
CREATE PROCEDURE SayCsHi
AS EXTERNAL NAME CsProcs.[CsTestNamespace.CsTestClass].SayHi
go
6、刷新程序集
ALTER ASSEMBLY CsProcs FROM 'D:\myDocuments\VS05_Programe\CS\Chapter09\HiCsWorld.dll'
GO
7、查看已安装程序集及其权限
SELECT * FROM sys.assemblies
8、注册带参数的存储过程
CREATE PROCEDURE GetGreeting
@name nvarchar(50),
@greeting nvarchar(100)
AS EXTERNAL NAME CsProcs.[CsTestNamespace.CsTestClass].GetGreeting
go
9、执行带参数的存储过程
DECLARE @result nvarchar(100)
EXEC GetCsGreeting 'SamYang',@result output
PRINT @result
