代码改变世界

Scheme 编程环境的设置(racket/petite)-王垠

2013-12-20 17:02 by allbymyself, 1441 阅读, 0 推荐, 收藏, 编辑
摘要:Scheme 编程环境的设置http://www.yinwang.org/blog-cn/2013/04/11/scheme-setup/sudo apt-get insatll racket;;paredit-mode(autoload 'paredit-mode "paredit" "Minor mode for pseudo-structurally editing Lisp code." t);;;;;;;;;;;;;; Scheme ;;;;;;;;;;;;(require 'cmuscheme)(setq scheme-pro 阅读全文

scheme代码高亮

2013-10-11 15:17 by allbymyself, 317 阅读, 0 推荐, 收藏, 编辑
摘要:(defun iedit-symbol-in-defun () "Enter `iedit-mode' to rename the symbol in current function, or exit it." (interactive) (if iedit-mode (progn (iedit-mode -1) (widen)) (progn (if (thing-at-point 'symbol) (progn (narrow-to-defun) (iedit-mod... 阅读全文

推荐的 CSS 书写顺序

2013-09-10 18:05 by allbymyself, 185 阅读, 0 推荐, 收藏, 编辑
摘要://显示属性displaylist-stylepositionfloatclear//自身属性widthheightmarginpaddingborderbackground//文本属性colorfonttext-decorationtext-alignvertical-alignwhite-spaceother textcontent扩展阅读:Mozilla suggested css order 阅读全文

SQL排除重复结果只取字段最大值

2013-09-02 14:31 by allbymyself, 2196 阅读, 0 推荐, 收藏, 编辑
摘要:如何用SQL排除重复结果只取字段最大值的记录?要求得到的结果(即是PID相同的记录只取ID值最大的那一条)。select * from [Sheet1$] awhere ID not exists (select 1 from [Sheet1$] where PID=a.PID and ID>a.ID)select a.* from [Sheet1$] a inner join (select PID,max(ID) as max_id from [Sheet1$] group by PID) b on a.PID=b.PID and a.ID=b.max_id 阅读全文

[转]从数据库中导出用友U8的现存量数据到Excel表

2013-09-02 14:16 by allbymyself, 1107 阅读, 0 推荐, 收藏, 编辑
摘要:转载自:http://www.czerp.com.cn/page/Default.asp?ID=372可通过Excel获取外部数据的方式与SQL数据库创建查询连接,并导入到Excel中:Select a.cWhcode 仓库编码,b.cWhName 仓库名称,a.cinvcode 存货编码,c.cInvName 存货名称,a.iquantity 结存数量,a.foutquantity 待发货数量,a.iquantity-a.foutquantity 可用量 from UFDATA_007_2011.dbo.CurrentStock a, --现存量汇总表UFDATA_007_2011.dbo. 阅读全文

SQL多表查询

2013-09-02 13:52 by allbymyself, 475 阅读, 0 推荐, 收藏, 编辑
摘要:MS SQL三表查询:select Inventory.cInvCode,Inventory.cInvName,max(dDate) from Inventory,SaleBillVouchs,SaleBillVouchwhere Inventory.cInvCode = SaleBillVouchs.cInvCodeand SaleBillVouchs.SBVID = SaleBillVouch.SBVIDgroup by Inventory.cInvCode,Inventory.cInvNameorder by Inventory.cInvCode select Inventory.cI. 阅读全文