devnambi / sql-server-regex Goto Github PK

Good Job!
1,Usually Replace function need replace something to empty,please fix .
2,download for 2008 ,2005 dll cannot execute 1load-assembly.sql,because the sqlserver didn't support .net 4.0.
TKS.

I get the following issue when running load-assembly.sql:

CREATE ASSEMBLY for assembly 'RegexAssembly' failed because assembly 'RegexAssembly' is malformed or not a pure .NET assembly.
Unverifiable PE Header/native stub.

Thanks for your code , it helps me a lot .
Since I'm not familiar with C# , I don't konw how to set the case sensitive off .
Could you please help me ?
Thanks!

Can someone please compile version for MSSQL 2019? Last compiled DLL is 2016.

Also 2019 version requires adding DLL hash to trusted DLLs, which should me mentioned in description.

Example for 2016 DLL version (hash is SHA2-512)

EXEC sp_add_trusted_assembly 0x52A8DC6C31B95961455746731FEC5DC4E8BF7F8791A6854473BB4F9A9577AA2BC4376213EC4AD9C3ADB0A0A55CEACCEBB9A01D7AC5CCBACA054B0F14EF4212D1 

Thanks

I tested your project, and had a little trouble with connecting from the worked database.
Please add script to registration
DECLARE @Sql NVARCHAR(MAX) = N'';

SELECT @Sql += CHAR(13) + CHAR(10)

• 'USE ' + QUOTENAME(name) + ';

IF OBJECT_ID(''dbo.RegexSplit'', ''FN'') IS NOT NULL
DROP FUNCTION dbo.RegexSplit;

IF OBJECT_ID(''dbo.RegexSplit'', ''SN'') IS NOT NULL
DROP SYNONYM dbo.RegexSplit

CREATE SYNONYM dbo.RegexSplit FOR master.dbo.RegexSplit;'
FROM sys.databases WHERE name <> 'master';

PRINT @Sql;

EXEC sp_executesql @Sql;