取得所有的name declare @str varchar(8000)set @str=''select @str=@str+name+'|' from 表名 where 1=1 order by nameprint @str