摘要：
="insert into tb_fdn_deviceaccount (zdmc,czmc,sbbh,sbmc,SZCS,SBFLMC,SBLXMC,SBGG,SBYZ,SBJZ,SBXH,SBZL,ZZDW,ZZNY,PPMC,GZYL,EDDY,SBGL,SYNY,SYR,JSZTMC,SBBD 阅读全文
posted @ 2017-04-27 10:33
萌橙
阅读(1584)
评论(0)
推荐(0)
摘要：
ceil和floor函数在一些业务数据的时候，有时还是很有用的。 ceil(n) 取大于等于数值n的最小整数； floor(n)取小于等于数值n的最大整数 如下例子 SQL> select ceil(9.5) from dual; CEIL(9.5) 10 SQL> select floor(9.5 阅读全文
posted @ 2017-04-21 10:35
萌橙
阅读(36493)
评论(3)
推荐(0)
摘要：
update tb_fdn_deviceaccount set czMC =replace(czMC,'站','') where zdmc in ('大连站','沈阳北站');delete from tb_fdn_deviceaccount where zdmc is null;update tb_ 阅读全文
posted @ 2017-04-20 13:49
萌橙
阅读(479)
评论(0)
推荐(0)
摘要：
--编号declare v_cnt number; V_SQL VARCHAR2 (500) := '';begin select count(*) into v_cnt from dual where exists(SELECT * FROM USER_TAB_COLUMNS WHERE TABL 阅读全文
posted @ 2017-04-10 16:49
萌橙
阅读(330)
评论(0)
推荐(0)
摘要：
declare v_cnt number; V_SQL VARCHAR2 (500) := '';begin select count(*) into v_cnt from dual where exists(SELECT * FROM user_tables WHERE TABLE_NAME = 阅读全文
posted @ 2017-04-10 16:48
萌橙
阅读(306)
评论(0)
推荐(0)
摘要：
using System;using System.Collections.Generic;using System.IO;using System.Linq;using System.Runtime.Remoting.Contexts;using System.Web;using System.W 阅读全文
posted @ 2017-04-10 16:44
萌橙
阅读(1065)
评论(0)
推荐(1)
摘要：
/^[+-]?\d+(\.\d+)?$|^$|^(\d+|\-){7,}$/ 阅读全文
posted @ 2017-04-10 16:44
萌橙
阅读(700)
评论(0)
推荐(0)
摘要：
SELECT w.ZDBH,w.HEATINGANDAIRCONDITIONERID, w.ZDMC, w.CZBH, w.CZMC, w.CNXS, w.ND, w.KTJF, w.KTJFMJ, w.KTZY, w.KTCS, w.KTJ, h.hMJ HCOUNT, a.hmj KCOUNTF 阅读全文
posted @ 2017-04-10 16:43
萌橙
阅读(275)
评论(0)
推荐(0)
摘要：
select train_code,count(1) from tb_ask_trainbodyroadtrain group by train_code having count(1) >1 阅读全文
posted @ 2017-04-10 16:42
萌橙
阅读(16180)
评论(0)
推荐(0)
摘要：
using KYZWeb.Common;using Liger.Data;//using Microsoft.Office.Interop.Excel;using System;using System.Collections.Generic;using System.Data;using Syst 阅读全文
posted @ 2017-04-10 16:41
萌橙
阅读(365)
评论(0)
推荐(0)
浙公网安备 33010602011771号