CREATE TABLE Staging.Sales
(
SaleID int not null primary key,
ProductName varchar(100) not null,
PricePaid money not null
);
GO
CREATE TABLE Archive.Sales
(
SaleID int not null,
ProductName varchar(100) not null,
PricePaid money not null,
RecordRetired datetime default getdate()
CONSTRAINT PK_Archive_Sales PRIMARY KEY (SaleID, RecordRetired)
);