01 2017 档案

dateTable
摘要：DataSet ds = dal.GetInventory(); foreach (DataTable dt in ds.Tables) { foreach (DataRow dr in dt.Rows) { InventoryList.Add(new icbc_invtorylist() { pr 阅读全文
posted @ 2017-01-24 16:08 applekingghfhfhbr 阅读(156) 评论(0) 推荐(0)
恢复数据
摘要：select * from 表 as of timestamp sysdate-(1/(24)); - 阅读全文
posted @ 2017-01-18 18:12 applekingghfhfhbr 阅读(99) 评论(0) 推荐(0)
省市区
摘要：select tt.shengid,tt.shengname,tt.shiid,tt.shiname,aa.area_id,aa.area_name from EXPRESSAREA aa inner join (select a.area_id shengid,a.area_name shengn 阅读全文
posted @ 2017-01-18 11:30 applekingghfhfhbr 阅读(132) 评论(0) 推荐(0)