With SQL Server 2016, you can store JSON objects ... expression to retrieve the entire contents of the column. The result, though, is the equivalent of just referencing the column. These two queries, ...

This lets you use JSON objects in your SQL ... query like this: Select JSON_VALUE(LastUpdate, '$.SignupDate') AS SignupDate, JSON_VALUE(LastUpdate, '$.Name.First') AS FirstName From Customers If the ...