02 2015 档案

VBA学习
摘要：1. Range / Cells / Columns / Rows 2. 绝对引用 $F$13 / 相对引用 F13 公式所在单元格的被复制到其他位置时，绝对引用不变 3. VLookup / NLookup / LLookup 4. =if(ISNA(C1:C17); "There are #N/ 阅读全文
posted @ 2015-02-13 11:07 h.yl 阅读(300) 评论(0) 推荐(0)
SQL 归来
摘要：1. PL/SQL 转义 select order#, ……… from **** select col1 from A where col2 like '%\_keywors%' escape '\'; update A set url = 'homepage.aspx?code=32' || ' 阅读全文
posted @ 2015-02-10 23:25 h.yl 阅读(769) 评论(0) 推荐(0)
EXPLAINING WHAT ACTION AND FUNC ARE
摘要：http://simpleprogrammer.com/2010/09/24/explaining-what-action-and-func-are/ Explaining What Action And Func Are In C#, Action and Func are extremely useful tools for reducing duplication in code an... 阅读全文
posted @ 2015-02-07 22:56 h.yl 阅读(197) 评论(0) 推荐(0)