To satisfy compliance standards, internal regulations or basic security principles, applications often need to limit a user’s access to only certain rows of data in a database.
Exporting Data as JSON – FOR JSON In this final post of our four-part JSON series, we showcase the ability to format query results as JSON text using the FOR JSON clause.
Transform JSON Text to Relational Table – OPENJSON OPENJSON is a table-value function (TVF) that looks into JSON text, locates an array of JSON objects, iterates through the elements of the array, and for each element returns one row in the output result.