IF EXISTS (SELECT 1 FROM dbo.sysobjects WHERE id = object_id(N'[$GetPageListProcName$]') AND OBJECTPROPERTY(id, N'IsProcedure') = 1)
  DROP PROCEDURE [$GetPageListProcName$]
GO
------------------------------------
--ÓÃ;£º»ñµÃ$ChinaComment$Êý¾ÝÁбí(·ÖÒ³)
--˵Ã÷£º
--×÷Õß: $Author$
--ʱ¼ä£º$CurDate$
------------------------------------
CREATE PROCEDURE $GetPageListProcName$
	$page_cols_params$
	@pageIndex  int,
	@pageSize int 
AS 
  DECLARE @startRow int, @endRow int

  SET nocount ON;

  SET @startRow = (@pageIndex - 1) * @pageSize +1 
  SET @endRow = @startRow + @pageSize -1 

  -- ²éѯ·ÖÒ³Êý¾Ý
  SELECT $strQueryCol_1$
  FROM 
  (
     SELECT ROW_NUMBER() Over(order by id desc ) AS row_num,
			$strQueryCol_2$
			FROM $TableName$ AS $TableAlias$ WITH(NOLOCK) 
			WHERE $where_cols_params$
  ) AS tabledata
  WHERE row_num  BETWEEN cast(@startRow as nvarchar(20)) AND +cast(@endRow as nvarchar(20)) 

  -- ²éѯ×ÜÌõÊý
  SELECT COUNT(1) AS COUNT FROM $TableName$ AS $TableAlias$ WITH(NOLOCK) 
  WHERE $where_cols_params$
   
  SET nocount OFF;
GO