摘要: to_char(cast(wd.itemcode as nvarchar2(32))) 阅读全文
posted @ 2016-08-12 16:53 blackhole1 阅读(1267) 评论(0) 推荐(0) 编辑
摘要: 1 public static bool CreateXML() 2 { 3 XMLMapMode xmlmodel = new XMLMapMode(); 4 Dictionary<string, object> dic = new Dictionary<string, object>(); 5 阅读全文
posted @ 2016-08-12 09:57 blackhole1 阅读(3267) 评论(0) 推荐(0) 编辑
摘要: with tt as( select ID,INFOTITLE,INFOCONTENT,CreateTime,CreateCode,IsRead ,data FROM (SELECT ID,INFOTITLE,INFOCONTENT,CreateTime,CreateCode,IsRead ,(se 阅读全文
posted @ 2016-08-12 09:40 blackhole1 阅读(508) 评论(0) 推荐(0) 编辑
摘要: with tt as(select s.MorOrAftOrEve, case s.MorOrAftOrEve when 1 then '上午' when 2 then '下午' else '晚上' end as MAE ,'第'+cast(s.Section as varchar(10))+'节' 阅读全文
posted @ 2016-08-12 09:38 blackhole1 阅读(179) 评论(0) 推荐(0) 编辑
摘要: select optorname, NVL(现金, 0) as 现金, NVL(银行卡, 0) as 银行卡, NVL(会员卡, 0) as 会员卡, NVL(礼品卡, 0) as 礼品卡, NVL(微信, 0) as 微信, NVL(支付宝, 0) as 支付宝, NVL(会员, 0) as 会员 阅读全文
posted @ 2016-08-12 09:33 blackhole1 阅读(162) 评论(0) 推荐(0) 编辑
摘要: create database link DBLINK_klyconnect to user_name identified By pwdusing '(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168. 阅读全文
posted @ 2016-08-12 09:25 blackhole1 阅读(2587) 评论(0) 推荐(0) 编辑