摘要: 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_AtractionsWHERE tcid>0 FOR xml ... 阅读全文