一个表有100多个字段需要设置别名(每个字段的别名存在另一个表中)

[moyumoyu]

如何用sql实现
select * as (select * from nametable where title=*) from report.

[發糞塗牆]

参考：

DECLARE @s NVARCHAR(4000)
SET @s = ''
SELECT  @s = @s + ',' + 'isnull('+QUOTENAME(name)+','''')'
FROM    syscolumns
WHERE   id = OBJECT_ID('表名')
        --AND name NOT IN ( '不希望显式的列' )
SET @s = STUFF(@s, 1, 1, '')
EXEC('select '+@s+' from 表名  ')

[moyumoyu]

thank you