ALTER PROCEDURE [dbo].[sp_CommSelect]
@ParamName VARCHAR(2000),/*查询字段字符串*/
@TableName VARCHAR(2000),/*表名*/
@ParamWhere NVARCHAR(2000)/*条件字符串*/
AS
BEGIN
DECLARE @Sql VARCHAR(5000)
set @Sql=‘select ‘+@ParamName+‘ from ‘+@TableName+‘ where 1=1 and ‘+@ParamWhere
exec(@Sql)
END
原文：http://www.cnblogs.com/DxiaoJ/p/4047120.html