For Json variations
| Index | Syntax | Description | Example (Simplified) | Results (Simplified) |
|---|---|---|---|---|
| 1 | FOR JSON PATH | Formats the result as JSON with nesting | SELECT name, surname FROM users FOR JSON PATH | [{ “name”: “John”, “surname”: “Doe” }] |
| 2 | FOR JSON PATH, ROOT(‘name’) | Adds a root element to JSON output | SELECT name FROM users FOR JSON PATH, ROOT(‘users’) | { “users”: [{ “name”: “John” }] } |
| 3 | FOR JSON AUTO | Automatically formats result as JSON | SELECT users.name, orders.order_id FROM users INNER JOIN orders ON users.user_id = orders.user_id FOR JSON AUTO | [{ “name”: “John”, “orders”: [{ “order_id”: 123 }] }] |
| 4 | FOR JSON AUTO, WITHOUT_ARRAY_WRAPPER | Formats JSON without an array wrapper | SELECT name FROM users FOR JSON AUTO, WITHOUT_ARRAY_WRAPPER | { “name”: “John” } |