12 2006 档案
摘要：3．SQL SERVER 2005中的新分页CREATE PROCEDURE [dbo].[Zhzuo_GetItemsPage2005] @PageIndex INT, @PageSize INT, @RecordCount INT OUT, @PageCount INT OUTAS/*获取记录数*/SELECT @RecordCount = COUNT(*) FROM Production.Product/*计算页面数据*/SET @PageCount = CEILING(@RecordCount * 1.0 / @PageSize)/* 基于SQL SERVER 2005 */SELEC
阅读全文
摘要：create proc Pager@PageIndex int,@PageSize int,@PageCount int out,@RecordCount int outasselect @RecordCount= count(*) from film_typeset @PageCount = CEILING(@RecordCount * 1.0 / @PageSize)declare @topCount intSET @topCount = @RecordCount - @PageSize * @PageIndex DECLARE @SQLSTR NVARCHAR(1000) if @Pag
阅读全文
