分页存储过程

USE [ChiefmesNEW]
GO
/****** Object: StoredProcedure [dbo].[st_MES_RS_Pages] Script Date: 04/22/2016 10:16:10 ******/
SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER OFF
GO
ALTER PROCEDURE [dbo].[st_MES_RS_Pages](
@in_total_rows int = 1
,@in_pagesize int = -1
,@in_page int = 1
,@out_row_from int = 0 output
,@out_row_to int = 0 output

)
/**************************************************
purpose: 記錄集公用分頁程序, 用以返回當前頁<最小>及<最大>順序號
created by: Wuchun on 2012/10/16
modified log: user/date/remark
**************************************************/
AS
if @in_pagesize > 0
select @out_row_from = ((@in_page-1) * @in_pagesize+1), @out_row_to = (@in_page * @in_pagesize)
else
select @out_row_from = 1, @out_row_to = @in_total_rows