- DECLARE @String VARCHAR(200)
- DECLARE @SqlText VARCHAR(MAX)
- DECLARE @Index INT=1;
- SET@String = 'A,
- B,
- C,
- D,
- E,
- F,
- G,
- H,
- G,
- H,
- I';
- SET @SqlText='SELECT COL='''+ REPLACE(@STRING,',',''' UNION ALL SELECT ''')+''''
- --清空旧数据,保存需要进行组合的字符串数据。
- TRUNCATE TABLE SplitString;
- INSERT INTO SplitString
- EXEC (@SqlText)
来源: http://www.bubuko.com/infodetail-1953681.html