Goyuix goyuix

bertwagner / Create Car Inventory Data.sql

Created June 17, 2017 11:50

Dataset for demos of how to solve 5 business problems with temporal tables https://medium.com/@bertwagner/5-business-problems-you-can-solve-with-temporal-tables-363255ed3a8c

	-- Drop and create our temporal and historical tables
	IF OBJECT_ID('dbo.CarInventory', 'U') IS NOT NULL
	BEGIN
	-- When deleting a temporal table, we need to first turn versioning off
	ALTER TABLE dbo.CarInventory SET ( SYSTEM_VERSIONING = OFF )
	DROP TABLE dbo.CarInventory
	DROP TABLE dbo.CarInventoryHistory
	END;
	CREATE TABLE CarInventory
	(