摘要:
1.关于SQL查询效率,100w数据,查询只要1秒,与您分享:机器情况p4: 2.4内存: 1 Gos: windows 2003数据库: ms sql server 2000目的: 查询性能测试,比较两种查询的性能SQL查询效率 step by step-- setp 1.-- 建表create ... 阅读全文
摘要:
create or replace procedure p_insert_caz_lims as v_sqlcode TLIMSERRORINFO.ERROR_CODE%type; v_msg TLIMSERRORINFO.error_msg%type;begininsert into ... 阅读全文
摘要:
PLSQL第一个最简单的函数create function sp_fun(name vachar2) returnnumber is year number(7,2);begin select sal from into year from emp where names=name;return y... 阅读全文