All Questions
2
questions
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);
...
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 ...