SELECT cast(id as varchar(8)) new_id FROM tourol_Atractions where tcid>0 order by new_id SELECT top 1 new_id = stuff ((SELECT ',' + cast(id as varchar(8)) FROM tourol_Atractions WHERE tcid>0 FOR xml path('')), 1, 1, '') FROM [tourol_Atractions] where tcid>0
结果如下
作者:石世特
出处:http://www.cnblogs.com/TivonStone/
希望本文对你有所帮助,想转随便转,心情好的话给我的文章留个链接.o(. .)o