通用分页存储过程（支持多表）

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go




ALTER PROCEDURE [dbo].[sp_page]
@CurrentPage int, 
@PageSize int,
@Tcount int,
@Field_Info varchar(500),
@Table_info varchar(500),
@OtherTable varchar(1000),
@Field_id varchar(1000),
@intOrder int,
@otherwhere varchar(1000),
@RecordCount int output,
@PageCount int output
--@CurrentPage为显示那一页,@PageSize为每一页显示几行,
--@Field_info为要显示的字段可以为*,@Table_info为要查询的表或视图,
--@field_id为按这个字段排序,@intorder0为升序排1为降序排,
--@otherwhere为条件,@RecordCount为总行数,@PageCount为总页数
AS
begin
DECLARE @MinPage int, @MaxPage int
declare @sql varchar(1000)
declare @sqlt nvarchar(300)
declare @order varchar(4)
declare @strWhere varchar(100)