The JSON data type can be used similarly to other data types. You can specify the JSON data type in these cases:
- In table definitions
- For input parameters and the return type in user-defined functions (UDFs), except for user-defined table operators written in C or C++.
- For input parameters and the return type in user-defined methods (UDMs)
- For IN, OUT, and INOUT parameters in external stored procedures
- For IN, OUT, and INOUT parameters in stored procedures
- In local variable definitions in stored procedures
- As an attribute of a structured user-defined type (UDT), but not as the base type of a distinct UDT