如何将范围字符串拆分到表中

-- 创建表
CREATE TABLE RangeTable (
  range_string VARCHAR(100),
  range_value INT
);

-- 范围字符串
DECLARE @rangeString VARCHAR(100) = '1-10,15-20,25-30';

-- 解析范围字符串并插入数据
DECLARE @startIndex INT = 1;
DECLARE @endIndex INT = CHARINDEX(',', @rangeString);
WHILE @endIndex > 0
BEGIN
  DECLARE @rangeValue VARCHAR(100) = SUBSTRING(@rangeString, @startIndex, @endIndex - @startIndex);
  DECLARE @dashIndex INT = CHARINDEX('-', @rangeValue);
  IF @dashIndex > 0
  BEGIN
    DECLARE @startValue INT = CAST(SUBSTRING(@rangeValue, 1, @dashIndex - 1) AS INT);
    DECLARE @endValue INT = CAST(SUBSTRING(@rangeValue, @dashIndex + 1, LEN(@rangeValue) - @dashIndex) AS INT);
    
    -- 插入范围值
    WHILE @startValue <= @endValue
    BEGIN
      INSERT INTO RangeTable (range_string, range_value) VALUES (@rangeValue, @startValue);
      SET @startValue = @startValue + 1;
    END;
  END;
  
  SET @startIndex = @endIndex + 1;
  SET @endIndex = CHARINDEX(',', @rangeString, @startIndex);
END;

-- 查询结果
SELECT * FROM RangeTable;