Announcing JSON Enhancements in Azure SQL Database, Azure SQL Managed Instance and SQL Server 2022

Thanks for this.

Can you please explain the SCALAR and VALUE type constraints added to the ISJSON function?

I'm at a loss to see the use case for the new type constraint SCALAR on the ISJSON function. You don't show a sample, and I'm unable to figure out what kind of JSON string returns 1 (true) for type constraint SCALAR.

I also don't see the value (no pun intended) of the new type constraint VALUE. It seems like ISJSON with the type constraint VALUE returns 1 (true) whether it's an array or an object, which is what ISJSON returns when no type constraint is specified at all (as per previous versions of SQL Server).

Thanks again!