我想这就是你想要的：

if object_id('FILE_LOOP', 'P') is not null
  drop procedure FILE_LOOP;
go

create PROCEDURE 
  FILE_LOOP(
  @V_FID varchar(4000),
  @V_NAME VARCHAR(4000) OUT) AS
  BEGIN
  SET NOCOUNT ON;
   DECLARE ITEM CURSOR FOR
   SELECT 
   ISNULL(V.PATHH, '') + '' +
   ISNULL(V.NAME, '') AS PATH 
   FROM 
   FILES T 
   INNER JOIN Table2 V ON T.FOLID=V.ID 
   WHERE T.ID IN( SELECT 
      RTRIM(LTRIM(REGEXP_SUBSTR(@V_FID ,'[^,]+', 1, LEVEL));
      FROM DUAL 
      CONNECT BY LEVEL <= 1 + REGEXP_COUNT(@V_FID ,',')))
  WHILE 1=1 
  BEGIN
  set @v_name=isnull(@V_NAME, '') + ISNULL(item.PATH, '');
  END;

 FETCH ITEM INTO;
 END;
 CLOSE ITEM;
 DEALLOCATE ITEM;

字符串

将此过程从Oracle转换到SQL Server的一种方法是使用游标：

CREATE or alter PROCEDURE FILE_LOOP
    @V_FID NVARCHAR(MAX),
    @V_NAME NVARCHAR(MAX) OUTPUT
AS
BEGIN
    DECLARE @Item NVARCHAR(MAX);
    DECLARE cur CURSOR FOR
        SELECT TRIM(value) AS ID
        FROM STRING_SPLIT(@V_FID, ',');

    SET @V_NAME = '';

    OPEN cur;
    FETCH NEXT FROM cur INTO @Item;

    WHILE @@FETCH_STATUS = 0
    BEGIN
        SELECT @V_NAME = @V_NAME + ' ' + V.PATHH + '\' + V.NAME
        FROM FILES T
        INNER JOIN Table2 V ON T.FOLID = V.ID
        WHERE T.ID = @Item;

        FETCH NEXT FROM cur INTO @Item;
    END;

    CLOSE cur;
    DEALLOCATE cur;
END;

字符串
您可以通过以下方式执行该过程：

DECLARE @OutputName NVARCHAR(MAX);
EXEC FILE_LOOP @V_FID ='11,22,33,444,98', @V_NAME = @OutputName OUTPUT;
SELECT @OutputName AS Result;

型
希望它能帮助