每一张表格行创建一个json

您将需要使用as子查询来实现此目的；

FOR JSON

CREATE TABLE #Sample (pre varchar(6));INSERT INTO #SamplevalUES ('D5ABX0'),       ('MKT536'),       ('WAEX44');SELECt (SELECT Code        FROM #Sample sq        WHERe sq.pre = S.pre        FOR JSON PATH)FROM #Sample S;DROP TABLE #Sample;