标签:分页

高效的SQLServer数据分页的通用存储过程

jaclon | 数据库 | 2010-11-10
IF EXISTS(SELECT * FROM sysobjects WHERE name = 'COMMON_PROCEDURE_QueryWithPage' AND type = 'P') DROP PROC COMMON_PROCEDURE_QueryWithPage GO CREATE PROC COMMON_PROCEDURE_QueryWithPage ( @SqlStr        VARCHAR(5000), @PrimaryKey    VARCHAR(100), @OrderStr      VARCHAR(500), @CurrPageNo    INT, ... [阅读全文]
Ɣ回顶部