SQL Server ->> CLR编程问题汇总

1) CLR不支持C#类方法重载(Method Overload) 

今天打算写个枚举目录的C# CLR存储过程，结果发现原来CLR不支持方法重载.

Msg 6572, Level 16, State 1, Procedure GetFileList, Line 12
More than one method, property or field was found with name ‘GetFileList‘ in class ‘StoredProcedures.EnumerateSourceFileDirectory‘ in assembly ‘XXXXXX‘. Overloaded methods, properties or fields are not supported.

2) SqlString类型对应的是NVARCHAR而不是VARCHAR

CREATE PROCEDURE GetFileList
(
    @SourceFolder NVARCHAR(2000),
    @BeginModDate DATETIME,
    @EndModDate DATETIME,
    @FileExtension NVARCHAR(50),
    @FileNamePattern NVARCHAR(2000),
    @IsSubfolderScanned SMALLINT
)
AS EXTERNAL NAME XXXX_CLR_Lib.[StoredProcedures.EnumerateSourceFileDirectory].GetFileListByBeginAndEnd;

Msg 6552, Level 16, State 3, Procedure GetFileList, Line 12
CREATE PROCEDURE for "GetFileList" failed because T-SQL and CLR types for parameter "@SourceFolder" do not match.

SQL Server ->> CLR编程问题汇总

原文：http://www.cnblogs.com/jenrrychen/p/4859187.html