Question

sql server 有表a，我要把表a的所有id读出来用逗号分开

Answer 1

declare @str varchar(8000)
select @str=isnull(@str,'')+convert(varchar,id)+',' from table
print @str

Answer 2

1> select * from a
2> go
id val
----------- ----------
1 B1
2 B2
3 A3

1> SELECT
2> STUFF(
3> (
4> SELECT
5> ',' + LTRIM( STR( id) )
6> FROM
7> A
8> FOR XML PATH('')
9> ),
10> 1, 1, '') AS ALL_ID
11> go

ALL_ID
-----------
1,2,3
(1 行受影响)