if exists (select name from sysobjects where name ='productSale')
drop table productSale

create table productSale (
buyer varchar(255)
, productName varchar(255)
, purchaseDate datetime
, qtypurchased int
, pricePaid decimal(9,2)
)

INSERT INTO productSale
VALUES('Shannon Lowder', 'paper', '1/1/2000', 2, 1.00)

INSERT INTO productSale
SELECT 'Shannon Lowder', 'paper', '1/1/2000', 2, 1.00

INSERT INTO productSale
(buyer, productName, qtyPurchased, pricePaid)
SELECT 'Shannon Lowder', 'paper', 2, 1.00

INSERT INTO productSale
(buyer, productName, qtyPurchased, pricePaid)
SELECT 'Shannon Lowder', 'paper', 2, 1.00

if exists (select name from sysobjects where name ='productSale_test')
drop table productSale_test

create table productSale_test (
buyer varchar(255)
, productName varchar(255)
, purchaseDate datetime
, qtypurchased int
, pricePaid decimal(9,2)
)

INSERT INTO productSale_test
(buyer, productName, qtyPurchased, pricePaid)
SELECT 
	  buyer
	, productName
	, qtyPurchased
	, pricePaid
from productSale

