I have the following JSON data : set @json = N'{ "Book":{ "IssueDate":"02-15-2019" , "Detail":{ "Type":"Any Type" , "Author":{ "Name":"Annie" , "Sex":"Female" } } , "Chapter":[ { "Sect...

Context: I'm having difficulty modifying a stored procedure in SQL Server 2016. The stored procedure performs parsing of json data within a file. For some reason I'm able to execute the stored proc...

I have an OPENJSON command that takes the parsed JSON and LEFT joins it onto an existing table. When I add the LEFT JOIN I get the error: collation conflict between "Latin1_General_BIN2"...

I am trying to connect to abfss directly(without mounting to DBFS) and trying to open json file using open() method in databricks. json_file = open("abfss://@.dfs.core.windows.net/test.json') ...

I'm trying to set the path for my OPENJSON function for the nested array, but it's not working. Tried different variations and examples/resources I found online and still cannot figure it out. Any ...

I have a table in a json file (C:\db.json): [{"_id":"81743561","_record_number":"1","_form_id":"618213","_user_id":"218754",...}, {"_id":"81782299","_record_number":"2","_form_id":"618213","_user_...

I have a temp table with multiple rows in it and each row has a column called Categories; which contains a very simple json array of ids for categories in a different table. A few example rows of...

I have a stored procedure that accepts a NVARCHAR(max) string that is JSON data that I need to validate before loading it into the live tables. If the validation fails I need to return a message wi...

Is it possible to combine parts of a json document from multiple array elements into a single result in Sql Server 2016? Given this json: { "fruit": { "types": [ { "possible": [ "Apples", "Ba...

I have some json that I would like to parse in SQL Server 2016. There is a hierarchy structure of Projects->Structures->Properties. I would like to write a query that parses the whole hierarchy but...