上一页 1 ··· 17 18 19 20 21
摘要: 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 萌橙 阅读(456) 评论(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 萌橙 阅读(319) 评论(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 萌橙 阅读(294) 评论(0) 推荐(0) 编辑
摘要: /^[+-]?\d+(\.\d+)?$|^$|^(\d+|\-){7,}$/ 阅读全文
posted @ 2017-04-10 16:44 萌橙 阅读(678) 评论(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 萌橙 阅读(1051) 评论(0) 推荐(1) 编辑
摘要: 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 萌橙 阅读(260) 评论(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 萌橙 阅读(16125) 评论(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 萌橙 阅读(353) 评论(0) 推荐(0) 编辑
摘要: 字体属性:(font)大小 {font-size: x-large;}(特大) xx-small;(极小) 一般中文用不到,只要用数值就可以,单位:PX、PD样式 {font-style: oblique;}(偏斜体) italic;(斜体) normal;(正常)行高 {line-height: 阅读全文
posted @ 2017-04-10 16:40 萌橙 阅读(176) 评论(0) 推荐(1) 编辑
上一页 1 ··· 17 18 19 20 21