Skip to main content
The 2024 Developer Survey results are live! See the results

All Questions

Tagged with
0 votes
0 answers
98 views

OPENJSON unable to parse Portuguese characters

I'm trying to convert my JSON data into a table format in SQL Server Express 2019. Following are my JSON data: DECLARE @token INT; DECLARE @ret INT; DECLARE @url NVARCHAR(MAX); ...
Hugo Pereira's user avatar
0 votes
0 answers
508 views

Dynamic SQL Query to read the jSon file or string using OpenjSon

I have a very large JSON string. I am trying to read using SQL for some report, but the JSON has objects embedded within in at least couple of levels. How can I read all the Data using one SQL query ...
AbdulAleem's user avatar