07 2015 档案

摘要:select FLIGHT_DATE, replace(wm_concat(FLIGHT_NO), ',', '*') FLIGHT_NOfrom T2001 group by FLIGHT_DATE 阅读全文
posted @ 2015-07-31 15:59 哥本哈根 阅读(1397) 评论(0) 推荐(0)
摘要:void uGrdAllFlight_InitializeRow(object sender, InitializeRowEventArgs e) { /***********TEST START**************/ ... 阅读全文
posted @ 2015-07-31 11:51 哥本哈根 阅读(507) 评论(0) 推荐(0)
摘要://最简单的方法是在Datagridview的事件RowPostPaint事件下面添加如下代码即可 private void dataGridView1_RowPostPaint(object sender, DataGridViewRowPostPaintEventArgs e) {... 阅读全文
posted @ 2015-07-30 17:32 哥本哈根 阅读(397) 评论(0) 推荐(0)
摘要:select * from all_triggers WHERE table_name='表名' 阅读全文
posted @ 2015-07-29 16:53 哥本哈根 阅读(3384) 评论(0) 推荐(0)
摘要:create or replace trigger TRI_PrintTest before delete or insert or update on TEST_EXAM --触发事件 for each row -- 每修改一行都需要调用此过程 b... 阅读全文
posted @ 2015-07-29 09:57 哥本哈根 阅读(2160) 评论(0) 推荐(0)
摘要:sql server 数表:select count(1) from sysobjects where xtype='U'数视图:select count(1) from sysobjects where xtype='V'数存储过程select count(1) from sysobjects w... 阅读全文
posted @ 2015-07-20 19:54 哥本哈根 阅读(211) 评论(0) 推荐(0)