By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
DECLARE @Item TABLE
(
ItemId INT,
Name VARCHAR(25)
);
INSERT INTO @Item
(
ItemId,
Name
)
VALUES
(
1,
'Item 1'
),
(
2,
'Item 2'
);
DECLARE @Property TABLE
(
PropertyId INT,
Name VARCHAR(10)
);
INSERT INTO @Property
(
PropertyId,
Name
)
VALUES
(
1,
'Property 1'
| (No column name) |
|---|
| {"ItemId":1,"Name":"Item 1","Property 1":true,","Property 2":true,","Property 3":false} |