摘要:
表 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 阅读全文
摘要:
// ===========================================================// 作者:ZhiQiao | MSN:zhiqiao84☆hotmail.com// 日期: 2009/06/25// 作用: 实用工具类,用于简化存储过程的调用。// 备注: .Net Framework 2.0 SQL Server 2005// =====... 阅读全文