日期:2014-05-16 浏览次数:20634 次
CREATE TABLE Invoice([ID] [INT],
AddressCode [VARCHAR](20),CreateTime [DATETIME]);
INSERT INTO Invoice(ID,AddressCode,CreateTime) VALUES(1,'C','2013/12/25 9:00')
INSERT INTO Invoice(ID,AddressCode,CreateTime) VALUES(2,'B','2013/12/25 9:30')
INSERT INTO Invoice(ID,AddressCode,CreateTime) VALUES(3,'A','2013/12/25 10:00')
INSERT INTO Invoice(ID,AddressCode,CreateTime) VALUES(4,'D','2013/12/25 11:00')
INSERT INTO Invoice(ID,AddressCode,CreateTime) VALUES(5,'C','2013/12/26 8:00')
INSERT INTO Invoice(ID,AddressCode,CreateTime) VALUES(6,'A','2013/12/26 9:00')
INSERT INTO Invoice(ID,AddressCode,CreateTime) VALUES(7,'D','2013/12/26 11:00')
INSERT INTO Invoice(ID,AddressCode,CreateTime) VALUES(8,'C','2013/12/27 10:00')
INSERT INTO Invoice(ID,AddressCode,CreateTime) VALUES(9,'A','2013/12/27 13:00')
INSERT INTO Invoice(ID,AddressCode,CreateTime) VALUES(10,'D','2013/12/27 13:30')
INSERT INTO Invoice(ID,AddressCode,CreateTime) VALUES(10,'B','2013/12/27 13:32')
CREATE TABLE Invoice([ID] [INT],
AddressCode [VARCHAR](20),CreateTime [DATETIME]);
INSERT INTO Invoice(ID,AddressCode,CreateTime) VALUES(1,'C','2013/12/25 9:00')
INSERT INTO Invoice(ID,AddressCode,CreateTime) VALUES(2,'B','2013/12/25 9:30')
INSERT INTO Invoice(ID,AddressCode,CreateTime) VALUES(3,'A','2013/12/25 10:00')
INSERT INTO Invoice(ID,AddressCode,CreateTime) VALUES(4,'D','2013/12/25 11:00')
INSERT INTO Invoice(ID,AddressCode,CreateTime) VALUES(5,'C','2013/12/26 8:00')
INSERT INTO Invoice(ID,AddressCode,CreateTime) VALUES(6,'A','2013/12/26 9:00')
INSERT INTO Invoice(ID,AddressCode,CreateTime) VALUES(7,'D','2013/12/26 11:00')
INSERT INTO Invoice(ID,AddressCode,CreateTime) VALUES(8,'C','2013/12/27 10:00')
INSERT INTO Invoice(ID,AddressCode,CreateTime) VALUES(9,'A','2013/12/27 13:00')
INSERT INTO Invoice(ID,AddressCode,CreateTime) VALUES(10,'D','2013/12/27 13: