如下脚本:
DECLARE @tmpTable TABLE (
NAME VARCHAR(100))
DECLARE @tmpStr VARCHAR(1000)
INSERT @tmpTable
SELECT 'Jim'
UNION
SELECT 'Tom'
UNION
SELECT 'Hellen'
SELECT *
FROM @tmpTable
SET @tmpStr=''
SELECT @tmpStr=@tmpStr+a.NAME+'/' FROM @tmpTable A --将name转换为了一个字符串
SELECT @tmpStr
执行结果:
NAME
----------
Hellen
Jim
Tom
(无列名)
--------------
Hellen/Jim/Tom/