使用 sysobjects 可以做到:

DECLARE @List varchar(2000)SELECT @List = COALESCE(@List + ',', '') + Cast(name As varchar(50))从 sys.sysobjects选择@List 作为列表"

i have this table

Cream
----------
CHOCALATE
GREEN
TEST

want out put in select query like this

cream

CHOCALATE,GREEN,TEST

With sysobjects this worked:

DECLARE @List varchar(2000)

SELECT @List = COALESCE(@List + ',', '') + Cast(name As varchar(50))
FROM sys.sysobjects

SELECT @List As 'List'