请问能不能通过查询把数据库字段的备注做为列名？

[lif]

请问能不能通过查询把数据库字段的备注做为列名？

[子陌红尘]

select
c.name as 字段名,
isnull(g.[value],'') as 备注
from
syscolumns c,sysproperties p
where
c.id = object_id('表名')
and
c.id=p.id and c.colid=p.smallid

[子陌红尘]

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

print @sql

exec(@sql)

[缪军]

赫赫
把楼上的 g.[value] 改成 p.[value]