作者:你的美丽来自我的设计 | 来源:互联网 | 2022-10-12 16:23
1> Zhorov..:
您可以尝试以下方法:
表:
CREATE TABLE Recommendations (
user_id int,
product1 varchar(100),
product2 varchar(100),
product3 varchar(100)
)
INSERT INTO Recommendations
(user_id, product1, product2, product3)
VALUES
(123, 'Scissors', 'Stone', 'Paper')
声明:
SELECT v.Name
FROM Recommendations r
CROSS APPLY (VALUES (r.product1), (r.product2), (r.product3)) v(Name)
WHERE user_id = '123'
FOR JSON PATH, ROOT('Offers')
结果:
{"Offers":[{"Name":"Scissors"},{"Name":"Stone"},{"Name":"Paper"}]}