存储过程模板

?

declare @p2_output int

exec [pr_view_order_status]

    @p2_output output

    ,@NowPage =1

        ,@VenderID=65

select @p2_output

 

ALTER PROCEDURE [dbo].[pr_Sys_InquiryOfOrdering]  --修改

CREATE PROCEDURE pr_Sys_ServiceRequest               --创建

        @outCount int output,

    @NowPage int =1,

    @PageSize int=20,

AS

BEGIN

        --写内容

 

END

GO