Tag
#json
2 snippets and 2 tools.
- Snippet SQL Server: Convert Between XML and JSON Turn XML into JSON with nodes() and FOR JSON, and JSON into XML with OPENJSON and FOR XML PATH, keeping nested rows nested.
- Tool XML to JSON Converter Convert XML to JSON and JSON back to XML, with attributes, repeated elements and namespaces handled the same way in both directions.
- Tool JSON to OPENJSON Generator Paste a sample JSON payload and get a SQL Server OPENJSON query with column types inferred from the data.
- Snippet SQL Server: Pass a List of IDs Without Dynamic SQL Turn a comma-separated or JSON list into rows you can JOIN to, with no string concatenation or SQL injection risk.