IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[RegexValue]') AND type in (N'FN', N'IF', N'TF', N'FS', N'FT'))
DROP FUNCTION [dbo].[RegexValue]
drop assembly [HSingle.SqlServer]
create assembly [HSingle.SqlServer]
from 'E:/LztD/项目/MyDB2000/HSingle/HSingle/HSingle.SqlServer/bin/Debug/HSingle.SqlServer.dll'
with permission_set=safe
go
CREATE FUNCTION [dbo].[RegexValue](@input [nvarchar](max), @pattern [nvarchar](4000))
RETURNS [nvarchar](4000) WITH EXECUTE AS CALLER
AS
EXTERNAL NAME [HSingle.SqlServer].[UserDefinedFunctions].[RegexValue]
GO
select * from sys.assemblies