Add a root node with the ROOT option

2016 (13.x) and later versions

Azure

SQL Managed Instance

(serverless SQL pool only)

analytics endpoint in Microsoft Fabric

Warehouse in Microsoft Fabric

SQL database in

Microsoft Fabric

To add a single, top-level element to the JSON output of the

clause, specify the

option.

If you don’t specify the

option, the JSON output doesn’t include a root element.

The following table shows the output of the

clause with and without the

option.

The examples in the following table assume that the optional

RootName

argument is empty. If

you provide a name for the root element, this value replaces the value

in the examples.

JSON

JSON

JSON

FOR JSON
ROOT
ROOT
FOR JSON
ROOT root
{
<<json properties>>
}
[
<<json array elements>>
]
{
"root"
: {
<<json properties>>
}
}