一个表Test有字段Name,有4条记录a,b,c,d,怎么用sql语句查出记录,结果只有1条记录,内容为"a,b,c,d"?
答案1:
DECLARE
@s
VARCHAR
(
100
);
SELECT
@s
=
''
;
SELECT
@s
=
@s
+
'
,
'
+
[
Name
]
FROM
TEST;
--
SELECT @s AS [Name]
SELECT
SUBSTRING
(
@s
,
2
,
LEN
(
@s
))
AS
[
Name
]