2015年7月8日
删除一个表里面的重复行
摘要： DELETE FROM dbo.table1 WHERE id NOT in (SELECT MIN(id) FROM dbo.table1 GROUP BY 全部的列名，除主键外 阅读全文
posted @ 2015-07-08 13:47 pengbg 阅读(153) 评论(0) 推荐(0)
Excel 创建31 个 工作表
摘要： Sub AddSheets()Dim i As IntegerDim DaysInt As IntegerDim NameStr As StringDaysInt = DateAdd("m", 1, Now) - NowNameStr = Month(Now) & "-"Application.Di... 阅读全文
posted @ 2015-07-08 09:14 pengbg 阅读(260) 评论(0) 推荐(0)