Using OPENJSON and a CROSS APPLY JOIN to Separate Arrays of JSON Object Types Published 2020-02-24 Download video MP4 360p Recommendations 06:46 Applying Schema to JSON Data Using OPENJSON's WITH Clause 08:51 CROSS APPLY vs CROSS JOIN - when should I use JOINs, and when should I use APPLY? 08:20 Customizing JSON Transformations in SQL Server Using FOR JSON PATH and Correlated Subqueries 54:19 Using JSON with SQL Server 2016 10:36 Parse JSON string with nested elements in SQL Server 09:11 Generating Multi-Object JSON Arrays in SQL Server 13:37 How Senior Programmers ACTUALLY Write Code 18:19 Generics: The most intimidating TypeScript feature 05:41 Querying and Updating JSON Data in a SQL Server Table 22:19 This Is Why Python Data Classes Are Awesome 12:00 Learn JSON in 10 Minutes 43:08 Deep dive: Using JSON with SQL Server 31:26 You don't need NoSQL (use MySQL) 19:25 Branchless Programming: Why "If" is Sloowww... and what we can do about it! 08:04 Clustered vs. Nonclustered Index Structures in SQL Server 11:25 Advanced SQL Tutorial Similar videos 01:26 SQL : Using cross apply to query nested arrays in json 01:29 SQL : SQL Server - recursively get into nested JSON array using cross apply or openjson or anything 03:25 Databases: Using CROSS APPLY OPENJSON causes Azure to hang (3 Solutions!!) 14:00 JSON. Learn isjson, json_value, openjson for SQL Server. 03:59 Read JSON data from a table and parse it to rows and columns 03:31 Flatten array with OPENJSON: OPENJSON on a value that may not be an array? [ [1] ], vs [1] 01:03 Array : How to Set OPENJSON Path to Nested Array 02:50 Learning OpenJson in Sql server (Lecture 14) 01:19 Databases: Join two Json arrays to one with key and value 00:57 Array : How to split json data into 2 different arrays? 03:48 JSON Openrowset and Openjson parser example 05:26 cross apply - cool trick in sql server 04:29 11 - Using SQL Join Convert result into JSON 01:14 Array : How to parse nested JSON array using SQL Server 01:18 Array : split json object from json array in java 04:09 SQL Basics: How To Use A CROSS APPLY and Why 02:17 Postgres select join json query More results