USE [IpointsInterface]
GO
/****** Object:  StoredProcedure [dbo].[VendorProductType_SelectPage]    Script Date: 11/07/2012 17:59:06 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:  Wayne Chen
-- Create date: 2012-11-07
-- Description: 获取大类对象分页
-- =============================================
ALTER PROCEDURE [dbo].[VendorProductType_SelectPage]
 @VendorIndex INT,
 @TypeCode varchar(32),
 @TypeName NVARCHAR(50),
 @PageSize int,
    @PageIndex int,
 @TotalCount int output
AS
BEGIN
 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 @End
END

具体怎么调用