Is there a way to return either a string or embedded JSON using FOR JSON?...

FOR JSON PATH vs FOR JSON AUTO SQL Server...

Create JSON from SQL Server 2016+ (using for JSON path command)...

SQL Server - "for json path" statement does not return more than 2984 lines of JSON string...