declare @tname varchar(40)
declare @sql varchar(8000)
set @tname='xxx'
set @sql=''
select @sql=@sql+','+c.name+' as ['+isnull(g.[value],c.name)+']' from syscolumns c,sysproperties p where c.id = object_id(@tname) and c.id=p.id and c.colid=p.smallid
order by c.colid
set @sql='select '+stuff(@sql,1,1,'')+' from '+@tname