All Questions
Tagged with open-json sql-server-2017
5
questions
0
votes
0
answers
251
views
SQL Server settings for OPENJSON
I have an instance of SQL Server running Microsoft SQL Server 2017 (RTM-CU31) (KB5016884) - 14.0.3456.2 (X64)
In one database, if I use JSON functions I get the following error:
Invalid object name '...
- 99
0
votes
1
answer
956
views
Json to table without explicit key names
I have a table with an VARCHAR(MAX) column which stores JSON key value pairs.
The JSON document schema is simply a different number of key value pairs, no nesting, nor arrays in there.
I wish to build ...
- 1,136
0
votes
1
answer
492
views
T-SQL JSON: JSON_QUERY is returning a json string after comparing the object with a string
I'm trying to return a JSON_QUERY field only if the JSON contains a specific field/property, but when I compare it with a string (that is the field's name), the function doesn't returns a JSON...
...
0
votes
1
answer
321
views
Issue with dynamic SQL to get JSON properties as columns when JSON is NULL
I am trying to select JSON properties as column. The properties that needs to be selected are stored in some other table
CREATE TABLE [Templates](
[ID] [int] NOT NULL,
[Template] [nvarchar](...
- 33.2k
0
votes
0
answers
820
views
Conditionally delete a json object from Json Array in SQL Server 2017
I am using Json Array to store child table records as a column in parent table. Now I have a requirement to conditionally delete one of the record from json array. If it would have been a table, I ...
- 479