sql server 2005启动CLR集成

利用c#在vs环境中新建sql server 项目，然后就可以编写存储过程，触发器之类的东东了，然后就可以部署到数据库里面去，查看发现有编写的存储过程

但是干这些之前得先启动clr集成代码如下

exec sp_configure 'show advanced options', '1';
go
reconfigure;
go
exec sp_configure 'clr enabled', '1'
go
reconfigure;
exec sp_configure 'show advanced options', '1';
go

--手动方法
create assembly [ClrOperateSql]
from 'C:\Documents and Settings\Administrator\桌面\jaylong\jaylong\clr集成\ClrOperateSql\ClrOperateSql\bin\Debug\ClrOperateSql.dll'
--创建存储过程GetAllCustomers
CREATE PROCEDURE GetAllCustomers
AS EXTERNAL NAME ClrOperateSql.StoredProcedures.GetAllCustomers
--创建存储过程GetCompanyName
CREATE PROCEDURE GetCompanyName
(
@CustomerID nchar(5),
@CompanyName nvarchar(40) output
)
AS EXTERNAL NAME ClrOperateSql.StoredProcedures.GetCompanyName
--测试Change
select * from customers
execute  Change 'ANTON','Alfreds Futter'
--测试GetCompanyName
declare @CompanyName nvarchar(40)
exec GetCompanyName 'ANTON',@CompanyName output
select @CompanyName

 

具体的代码在此提供下载，在下载目录里面