摘要：declare pageSize number; currentPage number; row_count number;--表的总行数 firstRow number;--分页查询第一条 lastRow number;-- 分页查询最后一条 pageTotalNum number;--总页数 process number;--过程 cur_1 number;--游标 table_name varchar2(100);--输入的表名 column_num number;--列数 tmp_sql varchar2(500); --动态sql语句 ... 阅读全文

摘要：using System;using System.Collections;using System.Data;using System.Linq;using System.Web;using System.Web.Services;using System.Web.Services.Protocols;using System.Xml.Linq;using System.Web.Security;using System.Web.UI;using System.Web.UI.HtmlControls;using System.Web.UI.WebControls;using System.W 阅读全文

摘要：--这句是执行语句exec sp_PublicTurnPage 'student',20,2,'SID','DESC','*','',''--创建存储过程create proc sp_PublicTurnPage2(@TBName nvarchar(2000)='student',--表名,如 pinyin@PageSize int =10,--每页的记录数,默认为 10@CurPage int =1,--表示当前页 1@KeyField nvarchar(100) ='SI 阅读全文