As mentioned earlier in this chapter, JSON has four primitive types (string, number, Boolean, and null) and two complex (structure) types: object and array. SQL Server 2016 offers two functions to extract values from a JSON text:

• JSON_VALUE: This is used to extract values of primitive data types.
• JSON_QUERY: This is used to extract a JSON fragment or to get a complex value (object or array).