USE BookShopDB

--Insert data from text files into 8 tables
--Data will be added to the other 3 tables in the database as orders are created
DELETE Authors
BULK INSERT Authors
FROM 'C:\authors.txt'
WITH (DATAFILETYPE = 'CHAR')
--Check data is now there
SELECT * FROM Authors

DELETE BookAuthors
BULK INSERT BookAuthors
FROM 'C:\bookauthors.txt'
WITH (DATAFILETYPE = 'CHAR')

SELECT * FROM BookAuthors

DELETE BookCondition
BULK INSERT BookCondition
FROM 'C:\bookcondition.txt'
WITH (DATAFILETYPE = 'CHAR')
SELECT * FROM BookCondition

DELETE Books
BULK INSERT Books
FROM 'C:\Books.txt'
WITH (DATAFILETYPE = 'CHAR')
SELECT * FROM Books

DELETE Customers
BULK INSERT Customers
FROM 'C:\Customers.txt'
WITH (DATAFILETYPE = 'CHAR')
SELECT * FROM Customers

DELETE Employees
BULK INSERT Employees
FROM 'C:\Employees.txt'
WITH (DATAFILETYPE = 'CHAR')
SELECT * FROM Employees

DELETE FormofPayment
BULK INSERT FormofPayment
FROM 'C:\FormofPayment.txt'
WITH (DATAFILETYPE = 'CHAR')

SELECT * FROM FormofPayment

DELETE OrderStatus
BULK INSERT OrderStatus
FROM 'C:\OrderStatus.txt'
WITH (DATAFILETYPE = 'CHAR')

SELECT * FROM OrderStatus

DELETE Positions
BULK INSERT Positions
FROM 'C:\Positions.txt'
WITH (DATAFILETYPE = 'CHAR')
SELECT * FROM Positions