Use sp_invoke_external_rest_endpoint in SQL Server 2025 with controlled permissions, JSON responses, protected credentials, and retries.
FOR JSON Data Types: How bit, Dates and Money Come Out
Your API returns 1 and the client wanted true. Here is how FOR JSON picks a JSON type for bit, dates, decimal, money, binary and NULL, and how to fix it.
SQL SERVER – Fix Error Msg 13602 working with JSON documents
Working with JSON documents in SQL Server 2016? You can’t use FOR JSON inside an UPDATE statement, and trying gives Msg 13602. Here is how to work around it.
SQL SERVER – Error Fix: Msg 13601 Working with JSON Structure
Msg 13601 showed up while I was working with JSON output: a property cannot be generated due to a conflict with another column name. Here is the fix.
OPENJSON WITH Clause: Converting JSON Properties to Typed Values
Without WITH, OPENJSON hands you text. With it, you pick the names and types and decide what happens when a property is missing.
SQL SERVER – 2016 – Check Value as JSON With ISJSON()
Before you store JSON sent from the front end, make sure it is valid. Here is how the ISJSON() function in SQL Server 2016 checks a value as JSON.
SQL SERVER – 2016 – Opening JSON with OPENJSON()
The next step with JSON in SQL Server 2016 is reading it. OPENJSON parses JSON text and returns properties as rows. A simple example with the default schema.