SQL Server行转列

– 创建表数据
CREATE TABLE #test ( id INT IDENTITY ( 1, 1 ) NOT NULL, name VARCHAR ( 255 ) NULL )

– 插入数据
INSERT INTO #test ( name )VALUES ( ‘张三，李四，王五’ );

SELECT
id,
SUBSTRING ( a.name, number, CHARINDEX( ‘,’, a.name + ‘,’, number ) - number ) AS name
FROM
#test a,
MASTER…spt_values
WHERE
number >= 1
AND number < len( a.name )
AND type = ‘p’
AND SUBSTRING ( ‘,’ + a.name, number, 1 ) = ‘,’