Instantly share code, notes, and snippets.

Embed
What would you like to do?
This file has been truncated, but you can view the full file.
-- 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)
)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment