Select json prop in sql

Tags: SQL

select SalesId, logdate
, JSON_VALUE([Data], '$.CreatedDate') as CDate
from #tmp
where SalesId = 123
and Data > ''
order by logdate desc