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