复制-- ================================= 删除先 ================================= -- -- MyCLRSqlserver 为程序集部署名称 IF EXISTS (SELECT * FROM sys.assemblies asms WHERE asms.name = NMyCLRSqlserver and is_user_defined = 1) BEGIN -- 删除集合函数。数署 IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N[dbo].[StrJoin]) AND type = NAF) DROP AGGREGATE dbo.StrJoin; -- 删除标量函数。据库集
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N[dbo].[___fun_CLR_ChangeSalarieScope]) AND type in (NFN,何手
NIF, NTF, NFS, NFT)) DROP FUNCTION dbo.___fun_CLR_ChangeSalarieScope; -- 删除其它... -- 卸载程序集。
网站模板 DROP ASSEMBLY [MyCLRSqlserver]; END; -- ================================= 重新创建 ================================= -- -- 注册程序集(如果是动部在服务器上部署，
WordPress模板需要将此dll复制到服务器，程序然后修改文件地址)。
站群服务器数署 CREATE ASSEMBLY [MyCLRSqlserver] FROM G:\AA\XX.dll; ---------------------- [dbo].[StrJoin] ---------------------- CREATE AGGREGATE [dbo].[StrJoin] (@Value [nvarchar](4000)) RETURNS[nvarchar](4000) EXTERNAL NAME [MyCLRSqlserver].[MyCLRSqlserver.StrJoin] GO EXEC sys.sp_addextendedproperty @name=NAutoDeployed,据库集 @value=Nyes , @level0type=NSCHEMA,@level0name=Ndbo, @level1type=NAGGREGATE,@level1name=NStrJoin GO EXEC sys.sp_addextendedproperty @name=NSqlAssemblyFile, @value=NStrJoin.cs , @level0type=NSCHEMA,@level0name=Ndbo, @level1type=NAGGREGATE,@level1name=NStrJoin GO EXEC sys.sp_addextendedproperty @name=NSqlAssemblyFileLine, @value=14 , @level0type=NSCHEMA,@level0name=Ndbo, @level1type=NAGGREGATE,@level1name=NStrJoin GO -- 其它函数创建过程... -- ================================= END ================================= -- 1.2.3.4.5.6.7.8.9.10.11.12.13.14.15.16.17.18.19.20.21.22.23.24.25.26.27.28.29.30.31.32.33.34.35.36.37.38.39.40.41.42.43.44.45.46.47.48.49.50.51.52.53.54.55.56.57.58.59.60.61.62.
