摘要:
1、两个统计量的减法:select (select count(*) from defect)-(select count(*) from defect where cljg like '%合格%' and cljg not like '%不合格%') as count from dual 阅读全文
摘要:
insert into scd_data_201007 select * from analog_data_201007 ; 阅读全文
摘要:
[代码]Code highlighting produced by Actipro CodeHighlighter (freeware)http://www.CodeHighlighter.com/--1///<summary>2///检查参数是否含有"'"3///</summary>4///<paramname="value">参数</param>... 阅读全文
摘要:
代码Code highlighting produced by Actipro CodeHighlighter (freeware)http://www.CodeHighlighter.com/--1///<summary>2///提取字符串中的数字字符串3///</summary>4///<paramname="str"></param>5///... 阅读全文
摘要:
代码Code highlighting produced by Actipro CodeHighlighter (freeware)http://www.CodeHighlighter.com/--publicstringGetClientBrowserVersions(){stringbrowserVersions=string.Empty;HttpBrowserCapabilitieshbc... 阅读全文
摘要:
问题:将JavaScript函数或代码放在<div></div> 或者<table> </table> <form> </form>内可能会出现此问题。[代码]解决办法: [代码] 阅读全文
摘要:
代码Code highlighting produced by Actipro CodeHighlighter (freeware)http://www.CodeHighlighter.com/--1usingSystem;2usingSystem.Collections.Generic;3usingSystem.Text;45namespaceSimpleDelegate6{7publicde... 阅读全文
摘要:
js实现: function setSize() { var myHeight=200; //窗口高度 var myWidth=400; //窗口宽度 window.resizeTo(myWidth,myHeight); window.moveTo((window.screen.availWidth-myWidth)/2,(window.screen.availHeight-myHeight)/2... 阅读全文
摘要:
纵表格式:pid dtag ttag dqf pval1001-1-1001 100 1 0 10.10横表格式:pid h1 h2 h3 Select --Pid,Substr(Pid, 8, 4) As Dev_Type,Substr(Pid, 0, 6) As Dev_Type,To_Char(To_Date('20000101', 'yyyymmdd') + Dtag, 'YYYY... 阅读全文
摘要:
pid:1001-01-01instr(real_data.pid,'-',1,1)):返回从左边开始第一次出现‘-’的位置。instr(real_data.pid,'-',-1,1)):返回从右边开始第一次出现‘-’的位置。 阅读全文