如下为列名带参数的存储过程
create proc list (@TableName varchar(100), @ListName varchar(300), @Value varchar(100)) as exec('select * from '+@TableName+' where '+@ListName+' like(''%'+@Value+'%'')')