下面有个简单的示例:
use pubs
declare @sql varchar(1000),
@queryfield varchar(50),
@wherefield varchar(50)
set @queryfield='au_lname,au_fname'
set @wherefield='au_lname'
set @sql='select ' + @queryfield + ' from authors where ' + @wherefield + '=''White'''
exec(@sql)