摘要:
前一段时间,老大给了个需求,就是对部分表进行了分库,所以,原库里面的存储过程、视图和函数里的表名等信息也要跟着更新,刚开始尝试手动检查了几个存储过程,可发现存储过程太多,检查起来效率很低,还容易出错,况且还有视图和函数,所以就想到了 Sql Server 内置的目录视图,找了一下,果然找到了解决办法:use ReportServer$SQLSERVER select a.name,a.[type],b.[definition] from sys.all_objects a,sys.sql_modules b where a.is_ms_shipped=0 and a.object_id = b 阅读全文
摘要:
1267715条数据,每页10条1.【第999980~999990页 0.327】【推荐】下图为测试第一页的时间SELECT ID, NAME, IDCARD, GENDER, STARFROM UsersWHERE ROWID IN (SELECT RID FROM (SELECT ROWNUM RN, RID FROM (SELECT ROWID RID FROM Users ORDER BY ID DESC) WHERE ROWNUM 0)ORDER BY ID DESC;2.【第99... 阅读全文
摘要:
//定义Circle类,拥有成员变量r,常量PI和计算面积的成员函数area()//第1种写法 function Circle(r) { this.r = r;}Circle.PI = 3.14159;Circle.prototype.area = function () { return Circle.PI * this.r * this.r;}var c = new Circle(1.0);alert(c.area());//第2种写法 var Circle = function() { var obj = new Object(); obj.PI = 3.... 阅读全文
摘要:
创建公共数据连接(Database Link)。-- Drop existing database link drop database link ERPBASE;-- Create database link create database link ERPBASEconnect to rdmdbtest identified by rdmdbtestusing '(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 172.29.129.31)(PORT = 1521)) ) (C... 阅读全文