如何解决SQL msg 6505创建函数RegExpLike [英] How to solve SQL msg 6505 Create Function RegExpLike

问题描述

Good Morning, Iam installing FUNCTION RegExpLike in SQLSERVER 2012 Express. During execute 
--function signature
CREATE FUNCTION RegExpLike(@Text nvarchar(max), @Pattern nvarchar(255)) RETURNS BIT
--function external name
AS EXTERNAL NAME SqlRegularExpressions.[qlRegularExpressions.SqlRegularExpressions].[Like]
GO

I have the next msg:

Msg 6505, Level 16, State 2, Procedure RegExpLike, Line 2
Could not find Type 'qlRegularExpressions.SqlRegularExpressions' in assembly 'SqlRegularExpressions'

Can You Help me to Solve.

Tky.

Regards

Eduardo Escalante

推荐答案

如错误信息所示，程序集 SqlRegularExpressions 在名称空间 qlRegularExpressions SqlRegularExpressions 的类型c>。



要修复它，您需要指定正确的类型和命名空间名称。由于我们无法在您的装配中看到代码，我们无法告诉您这是什么。



如果我不得不猜测，我会建议你'从命名空间名称中缺少前导 S ：

As the error message says, the assembly SqlRegularExpressions does not contain a type called SqlRegularExpressions in the namespace qlRegularExpressions.

To fix it, you need to specify the correct type and namespace name. Since we can't see the code in your assembly, we can't tell you what that is.

If I had to guess, I'd suggest you're missing a leading S from the namespace name:

CREATE FUNCTION RegExpLike(@Text nvarchar(max), @Pattern nvarchar(255)) RETURNS BIT
AS EXTERNAL NAME SqlRegularExpressions.[SqlRegularExpressions.SqlRegularExpressions].[Like]

这篇关于如何解决SQL msg 6505创建函数RegExpLike的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！