动态传字段参数给select语句一问

[辅导费卡了]

我是想实现
select top 2 fname from pubs.dbo.employee
这个功能，但是'fname'这个表的字段我要随时更换，因此写下如下语句

DECLARE @SQLString NVARCHAR(500)
DECLARE @ParmDefinition NVARCHAR(500)
declare @temp varchar(200),@tempword varchar(200)
SET @SQLString =N'SELECT top 2 @temp FROM pubs.dbo.employee'
SET @ParmDefinition = N'@temp varchar(200)'
set @tempword='fname'
EXECUTE sp_executesql @SQLString, @ParmDefinition,@temp=@tempword

但是给我返回两行'fname'，而不是数据库里面的内容。请教大侠！

[pengdali]

DECLARE @SQLString NVARCHAR(500)
DECLARE @ParmDefinition NVARCHAR(500)
declare @temp varchar(200)
set @temp='fname'
SET @SQLString =N'SELECT top 2 '+@temp+' FROM pubs.dbo.employee'

exec (@SQLString)

[yujohny]

DECLARE @SQLString NVARCHAR(500)
DECLARE @ParmDefinition NVARCHAR(500)
declare @temp varchar(200),@tempword varchar(200)
SET @SQLString =N'SELECT top 2 '+@temp+' FROM pubs.dbo.employee'
SET @ParmDefinition = N' @temp varchar(200)'
set @tempword='fname'
EXECUTE sp_executesql @SQLString, @ParmDefinition,@temp=@tempword

[txlicenhe]

Exec('select top ' + cast(@n as varchar(3)) + ' ' + @fname + ' from ' + @tablename )

[辅导费卡了]

sigh，这块到底高人多啊。。。pfpf

[辅导费卡了]

那我要实现下面这个呢？？？
declare @aa varchar(200)
select top 1 @aa=fname from pubs.dbo.employee
select @aa