/JSON Performance Tests redux.sql
Created Jun 3, 2017
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