--该写法是2008以下版本支持的 INSERT INTO BillInfo (BillID, BID, IWtime, Storage) select '1',1,'2012-11-19',100 union all select '2',1,'2012-11-19',100 union all select '3',1,'2012-11-19',100 union all select '4',1,'2012-11-19',100 //该写法是从2008版本开始支持 INSERT INTO BillInfo(BillID, BID, IWtime, Storage) Values('1',1,'2012-11-19',100),('1',1,'2012-11-19',100)