sqlserver 存储过程实现分页排序

create   PROCEDURE [dbo].[usp_list_product_pager]
    @page_index INT = 0 ,
    @page_size INT = 5 ,
    @total_row INT OUTPUT ,
    @Sort VARCHAR(40) ,
    @Desc VARCHAR(10)
AS
    BEGIN 
        DECLARE @start_index INT 
        --EasyUI 页序号从1开始，这里减一以修正
        SET @page_index = @page_index - 1
        SET @start_index = @page_size * @page_index
        DECLARE @table TABLE
            (
              new_index INT IDENTITY(1, 1)
                            NOT NULL ,
              id INT
            ) 
	
        SELECT  @total_row = COUNT(*)
        FROM    product WITH ( NOLOCK ) 
        
       
        INSERT  INTO @table
                ( id
		        )
                SELECT TOP ( @start_index + @page_size )
                        id
                FROM    product
                ORDER BY CASE WHEN @Sort = 'id'