sfsa

摘要： 1、分页的存储过程：create proc PageNum@PageSize int, --每页显示条数@PageIndex int, --当前是第几页@totalRows int output, --总行数@totalPages int output --总页数asdeclare @startId intdeclare @endId intset @startId = @PageSize*(@PageIndex-1)+1set @endId = @startId+@PageSize-1select @totalRows=COUNT(*) from Booksset @totalPages=@ 阅读全文