Consuming hierarchical JSON documents in SQL Server using OpenJSON

Over the years, Phil was struck by the problems of reading and writing JSON documents with SQL Server, and wrote several articles on ways of overcoming these problems. Now that SQL Server 2016 onwards has good JSON support, he thought that the articles would be forgotten. Not so, they continue to be popular, so he felt obliged to write about how you can use SQL Server's JSON support to speed the process up.

JSON Paths

Default OPENJSON

Understanding OPENJSON and FOR JSON in Azure and SQL 2016

An example of exporting and importing table data with JSON in Azure and SQL Server 2016.

Splitting Strings in SQL Server 2016

Comparison of the new methods of splitting strings in SQL Server 2016 to the tried and true methods

RE: Using Fetch--Help

Shelley,Frank is asking for a post of the table structures involved in the operation you're trying to perform... that way we might be able to find a non-cursor-based solution.SJT

RE: How about "None of the above" for the QOD on 10/20

If you are referring to the question:   Tab_A      Tab_B Id_A  Ds_A   Id_B Ds_B ----  -----  ---- ----       1   A1     2    B1   2   A2     3    B2   3   A3     4    B3 Select Id_A,Id_B,Ds_A,Ds_B from Tab_A    Join Tab_B      On Id_A = Id_B I would completely agree that none of the available answers is […]

RE: Paid-Time-Off Calculation.

Yuk! If no one has anything already written, I will help you out. Presume you're planning on using VBA? Regards Phil

RE: restoring a backupdevice on another machine

Solution:First check if the backupdevice exists on the machine (which it shouldn't, because the restore is taking place on a machine other than the one that the backup was done on.)oBackupDeviceCheck = CreateObject("sqldmo.BackupDevice")   For Each oBackupDeviceCheck In oServer.BackupDevices     If oBackupDeviceCheck.Name = BackupFileName Then         blnBackupDeviceExists = True         Exit For     End If Next […]

BACKUP PROBLEM

I', having a problem in my backup.This is the message:BackupDiskFile::CreateMedia: Backup device 'S:\Backup\Terca-Feira\BACKUP-TERCA-FEIRA.BAK' failed to create. Operating system error = 32(The process cannot access the file because it is being used by another process.). Dos someone knows what kind of error is this?? Regards,Felipe