如何在SQL Server 2017中将字符串解析为多个表

CREATE FUNCTION dbo.SplitString
(
    @String NVARCHAR(MAX),
    @Delimiter NVARCHAR(10)
)
RETURNS @Result TABLE (Item NVARCHAR(MAX))
AS
BEGIN
    DECLARE @Index INT
    DECLARE @Slice NVARCHAR(MAX)

    SELECT @Index = 1
    IF @String IS NULL RETURN

    WHILE @Index != 0
    BEGIN
        SELECT @Index = CHARINDEX(@Delimiter, @String)

        IF @Index != 0
            SELECT @Slice = LEFT(@String, @Index - 1)
        ELSE
            SELECT @Slice = @String

        INSERT INTO @Result(Item) VALUES(@Slice)

        SELECT @String = RIGHT(@String, LEN(@String) - @Index)
        IF LEN(@String) = 0 BREAK
    END

    RETURN
END

CREATE TABLE #TempTables (TableName NVARCHAR(MAX))

INSERT INTO #TempTables (TableName)
SELECT Item
FROM dbo.SplitString(@InputString, ',')

DECLARE @TableName NVARCHAR(MAX)

DECLARE TableCursor CURSOR FOR
SELECT TableName
FROM #TempTables

OPEN TableCursor

FETCH NEXT FROM TableCursor INTO @TableName

WHILE @@FETCH_STATUS = 0
BEGIN
    DECLARE @SQL NVARCHAR(MAX)

    SET @SQL = 'CREATE TABLE ' + @TableName + ' (Column1 INT, Column2 NVARCHAR(MAX))'

    EXEC(@SQL)

    -- 将数据插入表格
    SET @SQL = 'INSERT INTO ' + @TableName + ' (Column1, Column2) VALUES (1, ''Data 1'')'

    EXEC(@SQL)

    FETCH NEXT FROM TableCursor INTO @TableName
END

CLOSE TableCursor
DEALLOCATE TableCursor

SELECT * FROM TableName1
SELECT * FROM TableName2
-- ...查询其他解析后的表格