Listing 2: Doubling the Number of Rows in the Original Table

INSERT INTO SalesOrderHeader
SELECT  [RevisionNumber],[OrderDate],
   [DueDate],[ShipDate],[Status],
   [OnlineOrderFlag],[SalesOrderNumber],
   [PurchaseOrderNumber],[AccountNumber],
   [CustomerID],[ContactID],[SalesPersonID],
   [TerritoryID],[BillToAddressID],
   [ShipToAddressID],[ShipMethodID],
   [CreditCardID],[CreditCardApprovalCode],
   [CurrencyRateID],[SubTotal],[TaxAmt],
   [Freight],[TotalDue],[Comment],[rowguid],
   [ModifiedDate]
  FROM [Sales].[SalesOrderHeader]
GO
SELECT count(*) FROM SalesOrderHeader
GO