--用途：查询记录信息 
--项目名称：
--说明：
--时间：2012/6/25 8:53:15
------------------------------------
ALTER PROCEDURE [dbo].[T_assification_GetListByPage]
@sumnum int,
@page int,
@pagesize int,
@sort nvarchar(200)
AS
DECLARE @strsql nvarchar(1000)
set @strsql='SELECT TOP '+str(@sumnum)+' * FROM T_assification WHERE Classification_id NOT IN ( 
           SELECT TOP '+str(@pagesize*(@page-1))+' Classification_id FROM T_assification ORDER BY '+@sort+'
            )
ORDER BY '+@sort
EXEC(@strsql)