json to sql converter

easily be imported into other systems. Data exported as JSON If you want to export data from SQL Server to JSON, although this operation already has a very mature approach in your application, SQL Server does not natively support this approach (gossip, the next version will support). I recommend the way to use

Label: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 f

Single-table backupCode:Copy CodeThe code is as follows:　　PHP Backup Database code (generate Word,excel,json,xml,sql)