2014年3月7日
SQL自动补充其他月份为0
摘要： create table ProductSale(ID int identity(1,1) primary key,ProductName nchar(10), Sales int,Dates datetime)insert into ProductSaleselect 'A',100,'2014-01-05'UNION ALLselect 'A',200,'2014-02-05'UNION ALLselect 'A',300,'2014-03-05'UNION ALLselect 'B&# 阅读全文
posted @ 2014-03-07 17:21 橙子819 阅读(3161) 评论(0) 推荐(1)