数据库的分页处理

GO
DECLARE @PAGE INT/*页所含的记录条数*/
DECLARE @CURRENT INT/*当前页码*/
DECLARE @SQL NVARCHAR(1000)/*sql语句变量*/
SET @PAGE=4/*变量赋值*/
SET @CURRENT=3

/*要把整型变量变成字符型的用CAST*/
SET @SQL=N'SELECT TOP '+ CAST(@PAGE AS NVARCHAR(4))
SET @SQL=@SQL + N'* FROM S_INFO WHERE S_ID NOT IN('
SET @SQL=@SQL + N'SELECT TOP '+CAST((@CURRENT-1)*@PAGE AS NVARCHAR(5))
SET @SQL=@SQL + N' S_ID FROM S_INFO)'

/*用EXEC执行SQL语句*/
EXEC(@SQL)