Save data in a data table in JSON format with an SQL statement

No good tool found, only thought of the way to spell the string, with NVARCHAR(MAX) may have truncated, deprecated, the method uses the for XML PATH (" ) Implementation, refer here for its use method

　　

Table structure:

SQL statements:

SELECT '{"id":'+CONVERT(NVARCHAR( -), id)+', "AreaCode":'+AreaCode+', "AreaName": "'+AreaName+'" ," Paremt_areacode ":'+Paremt_areacode+'},'  fromHk_dic_countrycode forXML PATH ("')

Execution Result:

After formatting the result with the tool:

As can be seen from the results, the result is one more ",", "," Delete, and then "[]" wrapped up is the final result

Save data in a data table in JSON format with an SQL statement