Brzo kreiranje liste kolona neke tabele

declare @s varchar(max)

set @s = ''

select @s = @s + ',' + g.name

from syscolumns g

inner join sysobjects o on g.id = o.id and o.name = 'tHE_Move'

where g.iscomputed = 0 and Objectproperty(g.id,'IsUserTable')=1 and g.name <> 'anQid'

order by g.colorder

select right(@s, len(@s) -1)

--------------------------------

declare @s varchar(max)
set @s = ''

select @s = @s + ',' + name
from syscolumns
where id in (select id from sysobjects where name = 'tPA_SetDocType') and name <> 'anQid'
order by colorder

print @s