摘要: 表 tday qty1 42 13 7SELECT t1.day, (SELECT SUM(t2.qty) FROM t AS t2 WHERE t2.day <= t1.day) as acqty -- 累计数量FROM t AS t1查询结果day qty1 42 53 12 阅读全文
posted @ 2009-06-26 14:19 NanKe Sir's Blog 阅读(1417) 评论(0) 推荐(0) 编辑
摘要: // ===========================================================// 作者:ZhiQiao | MSN:zhiqiao84☆hotmail.com// 日期: 2009/06/25// 作用: 实用工具类,用于简化存储过程的调用。// 备注: .Net Framework 2.0 SQL Server 2005// =====... 阅读全文
posted @ 2009-06-26 12:50 NanKe Sir's Blog 阅读(1193) 评论(1) 推荐(0) 编辑