How to get json object property without using OPENJSON

Question

Following is my script to get specific value(OldPTValue, NewPTValue) from table HistoryTracking.
I'm using OPENJSON but getting compatibility issue.
Is there any way to get data without using OPENJSON in sql server 2016?

SELECT 
    (
        SELECT [Number] 
        FROM OPENJSON( CHT.OldValues, '$.Employee' ) 
        WITH ([Number] NVARCHAR(25) '$.PaymentTerms')) AS OldPTValue, 
    (
        SELECT [Number] 
        FROM OPENJSON( CHT.NewValues, '$.Employee' ) 
        WITH ([Number] NVARCHAR(25) '$.PaymentTerms')
    ) AS NewPTValue,
    CHT.InsertedBy,
    CHT.InsertedDate 
FROM HistoryTracking CHT 
ORDER BY CHT.Employee, CHT.InsertedDate desc

If you're experiencing compatibility problems your database's compatibility level. 2016 supports openjson but it requires compatibility level 130 or higher. — Zohar Peled, Oct 27 '19 at 14:38

score 1 · Accepted Answer · answered Oct 15 '19 at 12:16

1

I may be wrong, but it seems like that's what you may need there. https://learn.microsoft.com/en-us/sql/relational-databases/json/json-data-sql-server?view=sql-server-ver15

answered Oct 15 '19 at 12:16

Jaro Kolton

36
2

Thanks @Jaro Kolton your suggestion help me to complete my query. – Ritesh Gore Nov 11 '19 at 09:33

How to get json object property without using OPENJSON

1 Answers1