Skip to content
Advertisement

JSON_Query with For Json Path

Please see the table given below. The table contains the json string and need to create a json array with those json string. But When I use JSON_Query and For Json Path it adds additional header. (Alias name or the source column name). How to generate the json array without alias name or source column name.

Please see the example given below.

Advertisement

Answer

You can use OPENJSON() together with CROSS APPLY

Demo

User contributions licensed under: CC BY-SA
3 People found this is helpful
Advertisement