一个传入查询的存储过程

--exec R_Test 'select * from gdGoods'
CREATE PROCEDURE  R_Test
    @TestSerch varchar(100)
as
    declare @serch varchar(100)
    set @serch=@TestSerch
    exec (@serch)
GO



declare @serch varchar(100),@PageNum int
set @PageNum=4
set @serch='2'*@PageNum
set @serch= 'select top '+@serch+' * from gdGoods order by goodsNum'
exec (@serch)