成熟sql 分页存储过程(UP_General_SelectByWhere)

GO
/****** Object:  StoredProcedure [dbo].[UP_General_SelectByWhere]    Script Date: 03/17/2011 10:49:23 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:        <Author,,Name>
-- Create date: <Create Date,,>
-- Description:    <Description,,>
-- =============================================
ALTER PROCEDURE [dbo].[UP_General_SelectByWhere]    
    (
    @strSelect NVarChar (1000),
    @strWhere NVarChar (4000),
    @strTable NVarChar (50),
    @strOrderfld NVarChar (100),
    @OrderType bit = 0
    )
AS
    BEGIN
    DECLARE @strSQL varchar(8000) -- 主语句 
    DECLARE @strOrder varchar(400) -- 排序类型         
            IF(@strOrderfld!='')
                BEGIN
                    if @OrderType!= 0 -- 降序(desc) 
                        BEGIN 
                        set @strOrder = '  order by  ' + @strOrderfld +'   desc ' --如果@OrderType不是0，就执行降序，这句很重要!                     
                        END 
                    ELSE -- 升序(asc) 
                    BEGIN 
                        set @strOrder = ' order by  ' + @strOrderfld +'   asc ' 
                    END 
                   SET @strSQL=  ' select  '+@strSelect+'  from '+ @strTable+'     where 1=1  ' + @strWhere+@strOrder
                END
            ELSE
            BEGIN
                   SET @strSQL=  ' select  '+@strSelect+'  from  '+ @strTable+'     where   1=1   ' + @strWhere
            END
        EXECUTE(@strSQL)
    END