New: Intelligent Flashcards spaced-repetition decks for every topic, built to make things actually stick.
In SQL Server, what does JSON_VALUE(payload, '$.customer.name') return?
JSON_VALUE(payload, '$.customer.name')
A rowset with one row per element of the object
A scalar value (string or number) at the given JSON path
The full JSON object or array fragment located at the path