把字段，表名作为参数查询

CREATE procedure [dbo].[GT_QueryPayUnit]
(
@CName varchar(50),
@TableName varchar(50)
)
as
begin
 declare @Sql varchar(4000)

 set @sql='select Id,'+@CName+' as Unit
  from '+@TableName+''
 exec (@sql)
end

转载于:https://www.cnblogs.com/Garden-blog/archive/2011/08/10/2133923.html