By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
DECLARE @Json nvarchar(max) =
(
SELECT
JSON_QUERY((
SELECT 'Data1' AS [Data1], 'Data2' AS [Data2]
FOR JSON PATH
, INCLUDE_NULL_VALUES
, WITHOUT_ARRAY_WRAPPER
)) AS [Part1]
,
JSON_QUERY((
SELECT 'Text1' AS [Text1], 'Text2' AS [Text2]
FOR JSON PATH
, INCLUDE_NULL_VALUES
, WITHOUT_ARRAY_WRAPPER
)) AS [Part2]
FOR JSON PATH
, WITHOUT_ARRAY_WRAPPER
);
SELECT @Json;
| (No column name) |
|---|
| {"Part1":{"Data1":"Data1","Data2":"Data2"},"Part2":{"Text1":"Text1","Text2":"Text2"}} |