Casting a valid JSON string to the JSON type fails when a JSON object inside an array contains a string value of length ≥ 8 characters. The same payloads succeed when the string is ≤ 7 characters.
SQL Server's OpenJson function will let you dismantle JSON structures into relational tables, including tables with foreign/primary key relationships. As I noted in an earlier column, JSON is great ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results
Feedback