SQL FOR XML PATH

SELECT TOP 1000 convert(nvarchar(50),[id])+','
FROM table1
ORDER BY id DESC
FOR XML PATH('')

 

 

将table1  的id列  以 1,2,3,4 形式查询出来