USE [IpointsInterface]GO/****** Object:? StoredProcedure [dbo].[VendorProductType_SelectPage]??? Script Date: 11/07/2012 17:59:06 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGO-- =============================================-- Author:??Wayne Chen-- Create date: 2012-11-07-- Description:?獲取大類對(duì)象分頁-- =============================================ALTER PROCEDURE [dbo].[VendorProductType_SelectPage]?@VendorIndex INT, ?@TypeCode varchar(32),?@TypeName NVARCHAR(50),?@PageSize int,??? @PageIndex int,?@TotalCount int outputASBEGIN?SET NOCOUNT ON;??? DECLARE @Start INT,@End INT??? SET @Start = (@PageIndex -1) * @PageSize+1;??? SET @End = @PageIndex *@PageSize??? -- Insert statements for procedure here??? SELECT @TotalCount = COUNT(1) FROM VendorProductType(NOLOCK)??? WHERE VendorIndex=@VendorIndex??? AND (TypeCode LIKE @TypeCode)??? AND (TypeName LIKE @TypeName)??? ??? SELECT * FROM(??? SELECT ROW_NUMBER() OVER(ORDER BY VendorProductTypeIndex ASC) iRowNum,* FROM VendorProductType(NOLOCK)??? WHERE VendorIndex=@VendorIndex??? AND (TypeCode LIKE @TypeCode)??? AND (TypeName LIKE @TypeName)) AS [TMP]??? WHERE iRowNum BETWEEN @Start AND @EndEND ? ? ? 具體怎么調(diào)用