mxj_2001382的专栏

 set ANSI_NULLS ONset QUOTED_IDENTIFIER ONgo--创建存储过程CREATE PROCEDURE [dbo].[SP_xxx_GetPageOfRecords]  @pageSize int = 20,                                                --分页大小  @currentPage int ,   

create procedure SqlDataPaging@tbName varchar(255),        --表名@tbFields varchar(1000),      --返回字段@OrderField varchar(255),   --排序的字段名@PageSize int,                 --页尺寸@PageIndex int,              

declare @t table (时间 datetime,金额 int)insert @t select    2007-1-1 10:00:23,           8 --union all select    2007-1-1 01:00:04,           4 union all select    2007-1-1 01:00:14,           4 un