devnambi / sql-server-regex Goto Github PK
View Code? Open in Web Editor NEWRun regular expressions in SQL Server
License: GNU Affero General Public License v3.0
Run regular expressions in SQL Server
License: GNU Affero General Public License v3.0
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!
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)
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;
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
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.
A declarative, efficient, and flexible JavaScript library for building user interfaces.
๐ Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
An Open Source Machine Learning Framework for Everyone
The Web framework for perfectionists with deadlines.
A PHP framework for web artisans
Bring data to life with SVG, Canvas and HTML. ๐๐๐
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
Some thing interesting about web. New door for the world.
A server is a program made to process requests and deliver data to clients.
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
Some thing interesting about visualization, use data art
Some thing interesting about game, make everyone happy.
We are working to build community through open source technology. NB: members must have two-factor auth.
Open source projects and samples from Microsoft.
Google โค๏ธ Open Source for everyone.
Alibaba Open Source for everyone
Data-Driven Documents codes.
China tencent open source team.