document.write('
Data hosted with ♥ by Pastebin.com - Download Raw - See Original
  1. CREATE TABLE Staging.Sales
  2. (
  3.     SaleID int not null primary key,
  4.     ProductName varchar(100) not null,
  5.     PricePaid money not null
  6. );
  7.  
  8. GO
  9.  
  10. CREATE TABLE Archive.Sales
  11. (
  12.     SaleID int not null,
  13.     ProductName varchar(100) not null,
  14.     PricePaid money not null,
  15.     RecordRetired datetime default getdate()
  16.     CONSTRAINT PK_Archive_Sales PRIMARY KEY (SaleID, RecordRetired)
  17. );
');