A JSON document contains an array of line items that must be exposed as rows for a relational query. Which function fits?

Published
  1. OPENJSON with an appropriate schema or mapping
  2. JSON_VALUE alone as an arbitrary array-to-rowset operator
  3. A backup operation
  4. A database collation change

Comments — 0