摘要：/*通用分页存储过程*/USE HotelManagementSystemGOIF EXISTS(SELECT * FROM sys.objects WHERE NAME='cndoup_GetPageOfRecords')DROP PROCEDURE cndoup_GetPageOfRecordsGO--创建存储过程CREATE PROCEDURE cndoup_GetPageOfRecords@pageSize int = 20,--分页大小@currentPage int , --第几页@columns varchar(1000) = '*',--需要得到 阅读全文