Listing 1: Creating dbo.OrderHeader and dbo.Customer Tables

USE AdventureWorks
GO
CREATE TABLE dbo.OrderHeader(
  RowNum int IDENTITY (1, 1)
    NOT NULL,
  SalesOrderID int  NOT NULL,
  RevisionNumber tinyint NOT NULL,
  OrderDate datetime NOT NULL,
  DueDate datetime NOT NULL,
  ShipDate datetime NULL,
  Status tinyint NOT NULL,
  OnlineOrderFlag Flag NOT NULL,
  SalesOrderNumber nvarchar(25)
    NOT NULL,
  PurchaseOrderNumber
    OrderNumber NULL,
  AccountNumber
    AccountNumber NULL,
  CustomerID int NOT NULL,
  ContactID int NOT NULL,
  SalesPersonID int NULL,
  TerritoryID int NULL,
  BillToAddressID int NOT NULL,
  ShipToAddressID int NOT NULL,
  ShipMethodID int NOT NULL,
  CreditCardID int NULL,
  CreditCardApprovalCode varchar(15)
    NULL,
  CurrencyRateID int NULL,
  SubTotal money NOT NULL,
  TaxAmt money NOT NULL,
  Freight money NOT NULL,
  TotalDue money NOT NULL,
  Comment nvarchar(128) NULL,
  rowguid uniqueidentifier NOT NULL,
  ModifiedDate datetime NOT NULL
)
GO

INSERT INTO OrderHeader (
  SalesOrderID, 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)
SELECT * FROM Sales.SalesOrderHeader
GO 10

SELECT * INTO Customer
FROM  Sales.Customer
GO