Slide 13
Slide 13 text
JSON Colums
SELECT (((((([a].[Name] + N' (') +
CAST(JSON_VALUE([a].[Contact],'$.Address.Street') AS nvarchar(max))) + N', ')
+ CAST(JSON_VALUE([a].[Contact],'$.Address.City') AS nvarchar(max))) + N' ')
+ CAST(JSON_VALUE([a].[Contact],'$.Address.Postcode') AS nvarchar(max))) +
N')' FROM [Authors] AS [a] WHERE
(CAST(JSON_VALUE([a].[Contact],'$.Address.City') AS nvarchar(max)) =
N'Chigley' AND CAST(JSON_VALUE([a].[Contact],'$.Phone') AS nvarchar(max))
IS NOT NULL) OR ([a].[Name] LIKE N'D%') ORDER BY
CAST(JSON_VALUE([a].[Contact],'$.Phone') AS nvarchar(max))