曆數了一些我尋找設計構想時經常訪問的網站。在文章的最後,我給大家扔了個問題:“你會到什麼網站找設計構想呢?”。那下面呢,就是一些看官推薦的網站。有些我沒聽過,有些網站已經在我的收藏夾了:) 廢話不多說 - 16個看官經常訪問的列數如下: 1. The Best Designs 提供者: chandan (Digg profile) 以前介紹過這個The Best Designs,所以這次就不細數它的優點了。對此站不甚瞭解的朋友來說,The Best Designs
Whenthe debugger is not an option... Good Thursday morning It'll be short this morning, one customer's Ax 5.0 migration work isstarting to pile up, and another customer's Ax 4.0 migration is nearing atesting milestone... So today, I'm posting a
1.子查詢回顧 SELECT select_list FROM table WHERE expr operator(SELECT select_list FROM table); 例1:查詢emp表,顯示薪水大於平均薪水的僱員資訊 SELECT * FROM emp WHERE sal>(SELECT AVG(sal) FROM emp);
1.建立索引 CREATE INDEX index ON table (column [,column]...); 例1:提高對EMP表的ENAME的查詢速度 CREATE INDEX emp_ename_idx ON emp(ename); 例2.建立基於函數的索引 CREATE INDEX upper_idx ON emp(upper(ename));2.驗證索引 USER_INDEXES資料字典視圖包含索引的名稱及其唯一性
Copy from:http://www.bizbert.com/bizbert/2007/09/01/How+To+Validate+Xml+Documents+Against+Schemas+In+BizTalk.aspx How to validate Xml Documents against schemas inBizTalk I got asked a question the other day: How would youvalidate an incoming message
1.分級查詢 SELECT [LEVEL],column,expr... FROM table [WHERE condition(s)] [START WITH condition(s)] [CONNECT BY PRIOR condition(s)]; LEVEL:對每行返回一個層級,對根行LEVEL偽列返回1;對孩子的LEVEL偽列返回2,以此類推 START WITH:指定層次的根行 CONNCT BY PRIOR:指定查詢的方向1)START