JSON Performance Tests redux.sql

-- Create our test data: A table of a car dealer's inventory of cars
-- car data source: https://github.com/arthurkao/vehicle-make-model-data
DROP TABLE IF EXISTS dbo.AllCarsInOneRow
CREATE TABLE dbo.AllCarsInOneRow
(
	Id INT IDENTITY(1,1),
	CarDetails NVARCHAR(MAX)
);
DROP TABLE IF EXISTS dbo.XmlVsJson
CREATE TABLE dbo.XmlVsJson
(
  Id INT IDENTITY PRIMARY KEY,
  XmlData XML,
  JsonData NVARCHAR(MAX)
)