创建存储过程create procedure MyProc@para1 int, --参数一with encryption--加密asselect top @paral * from 表名 where PicUrl<>' '使用存储过程exec MyPro 10
Exec('select top '+@Num+' PicUrl,* form Test where PicUrl is not null')
