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
Tags: SQL
select SalesId, logdate
, JSON_VALUE([Data], '$.CreatedDate') as CDate
from #tmp
where SalesId = 123
and Data > ''
order by logdate desc