关于字段别名的使用

[dofly]

SELECT A1 AS (SELECT COLNAME FROM TEST WHERE ID='A1') FROM TESTTABLE

上面的语句中，我想把 A1 的别名从 Test 中取出来，

可是语句通不过，提示：
Server: Msg 170, Level 15, State 1, Line 1
Line 1: Incorrect syntax near '('.
Server: Msg 156, Level 15, State 1, Line 1
Incorrect syntax near the keyword 'FROM'.

请大家指点一下，可不可以把字段别名从数据库中取出来

[qizhanfeng]

declare @s varchar(200)
select @s = 'select A1 as ['+colname+'] from testtable ' from test where id ='A1'
print @s
exec (@s)