摘要:
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 阅读全文