StackOverflow Questions for Tag: for-json

ttugates
ttugates

Reputation: 6271

How to aggregate and Join or Union into flat Json object with arrays?

Score: 3

Views: 1421

Answers: 1

Read More
Graham
Graham

Reputation: 8151

How to select multiple rows as multiple rows using for json path

Score: 0

Views: 1380

Answers: 2

Read More
Pawan Alur
Pawan Alur

Reputation: 97

SQL Server get a JSON of all distinct columns grouped by a different column

Score: 0

Views: 539

Answers: 1

Read More
Sirth
Sirth

Reputation: 99

How to run SQL script only on JSON keys that exist

Score: -1

Views: 99

Answers: 1

Read More
Brad Mathews
Brad Mathews

Reputation: 1857

JSON AUTO in SQL Server Query is Duplicating Records in Parent Array

Score: 0

Views: 70

Answers: 0

Read More
Avinash
Avinash

Reputation: 99

How to query all system under SystemTypes in SQL database in a json format

Score: 0

Views: 52

Answers: 1

Read More
Chris Ward
Chris Ward

Reputation: 817

T-SQL FOR JSON PATH but without a column name in the JSON result

Score: 2

Views: 1021

Answers: 0

Read More
Ceci Semble Absurde.
Ceci Semble Absurde.

Reputation: 530

How to generate empty JSON array in SQL Server?

Score: 0

Views: 1335

Answers: 1

Read More
Sky Monster
Sky Monster

Reputation: 53

Azure Logic App - Result Set from Stored procedure

Score: 0

Views: 4234

Answers: 2

Read More
Tatou
Tatou

Reputation: 61

FOR JSON PATH in CASE statement

Score: 5

Views: 1952

Answers: 1

Read More
OMayhew
OMayhew

Reputation: 1

How to exclude escape characters from ROOT when using FOR JSON from SQL server

Score: -1

Views: 953

Answers: 1

Read More
WillC
WillC

Reputation: 2115

SQL Server 2016 SSMS Json Formatting

Score: 6

Views: 6294

Answers: 3

Read More
Steve
Steve

Reputation: 99

Query for JSON value with unexpected character in path

Score: 0

Views: 1269

Answers: 1

Read More
hollecar
hollecar

Reputation: 17

SQL Server Nested object with FOR JSON PATH

Score: 1

Views: 2026

Answers: 1

Read More
Matheus Seixas
Matheus Seixas

Reputation: 33

Is there any way to build a JSON that looks like this using SQL Server 2019?

Score: 1

Views: 74

Answers: 1

Read More
Coilover
Coilover

Reputation: 49

What is the best practise for outputting JSON Type arrays from Table values without repetition?

Score: 1

Views: 53

Answers: 2

Read More
OJ Slott
OJ Slott

Reputation: 79

SQL Generate JSON string using FOR JSON PATH with 2 ROOTs

Score: 4

Views: 1154

Answers: 1

Read More
Saiteja Sedate
Saiteja Sedate

Reputation: 55

Nested JSON path

Score: 1

Views: 305

Answers: 2

Read More
tommyhmt
tommyhmt

Reputation: 327

Turn Rows into Multiple elements in JSON

Score: 1

Views: 28

Answers: 0

Read More
Cees M
Cees M

Reputation: 3

How to split column headers & values in TSQL FOR JSON Option?

Score: 0

Views: 404

Answers: 1

Read More
PreviousPage 2Next