adventure works database for sql server 2016 express

Create three new JSON columns in Sales.Sales_json table that will contain sales reasons and order items, and various information about sales orders.Populate EmailAddresses JSON column with the content of related email addresses from Person.EmailAddress table.Populate PhoneNumbers JSON column with the content of related phone numbers from Person.PersonPhone and Person.PhoneNumberType tables.Create two new JSON columns in Person.Person_json table that will contain JSON text with arrays of phone numbers and email addresses.In this script you will see SQL statements that perform following actions: This script generates JSON data and stores JSON text in new Person.Person_json and Sales.SalesOrder_json tables. Even if you don't need de-normalization you will need this script because this is prerequisite for all other scripts. De-normalizationįirst script you would need to run is de-normalization script. In the following sections we will see short explanations of these scripts. These are scripts that show how to use various JSON features in this database. In SQLServer2016CTP3Samples.zip (attached) you will find JSON folder with the following content: Note that when you install AdventureWorks2016CTP3 database you don't have any JSON data in this table - you will need to run de-normalization script described below to populate tables with JSON data. These tables are just copies of the existing Person.Person and Sales.SalesOrderHeader tables. Sales.SalesOrder_json table that will contain information related to Sales orders.Person.Person_json table that will contain information related to person records.These are new tables that are used in example scripts.įor JSON support are added two new tables: When you download AdventureWorks2016CTP3 database you will notice that there are a lot of new tables with sufixes _json, _temporal_inmemory, etc.

In this post we will see short description of the files in this folder. One of the folders in this archive is JSON folder where you can find some JSON example scripts. In SQLServer2016CTP3Samples.zip file (attached in this post) you can find various example scripts that show how to use various features added in SQL Server 2016. New database and samples for AdventureWorks 2016 CTP3 database are published on AdventureWorks Sample Databases and Scripts for SQL Server 2016 CTP3.

Adventure works database for sql server 2016 express