适用于简单场景的行转列

DECLARE @ListStr VARCHAR(1000)

DECLARE @TB_Fee TABLE (FeeCode VARCHAR(10), Fee NUMERIC(18,2))

INSERT INTO @TB_Fee(FeeCode, Fee)
SELECT '10', 10
UNION
SELECT '11', 11
UNION
SELECT '12', 12

SET @ListStr = ''

SELECT @ListStr = @ListStr + '{"FeeCode":"' + FeeCode
+'","Fee":"' + CONVERT(VARCHAR(20), Fee) + '"},'
FROM @TB_Fee

SET @ListStr = SUBSTRING(@ListStr, 1, LEN(@ListStr) - 1)
SET @ListStr = '{[' + @ListStr + ']}'

SELECT  @ListStr