INSERT INTO CustomerOrder1 SELECT TOP 10 [GoodsID]
,[ProductName]
,[OrderTime]
,[DeliveryTime]
,[Model]
,[ProductNum]
,[FirstPartID]
,[TotalMoney]
,[AdvanceMoney]
,[OrderDetail]
,[ProductName]
,[OrderTime]
,[DeliveryTime]
,[Model]
,[ProductNum]
,[FirstPartID]
,[TotalMoney]
,[AdvanceMoney]
,[OrderDetail]
FROM CustomerOrder
INSERT INTO CustomerOrder1 SELECT * FROM CustomerOrder