JsonEscape

Returns a JSON escaped string

Syntax:

SELECT SQLHTTP.net.JsonEscape ( @JsonValue )

Arguments:

Name	Type	Description
@JsonValue	nvarchar(MAX)	Json value to escape

Return Type:

nvarchar(MAX)

Remarks:

Json escaping is NOT always identical to Regex escaping, but Json un-escaping IS always identical to Regex un-escaping.

Sample Usage:


DECLARE @JsonValue nvarchar(MAX)
 
SET @JsonValue = '"C:\temp"'
 
SELECT SQLHTTP.net.JsonEscape(@JsonValue)

DECLARE @JsonValue nvarchar(MAX)

SET @JsonValue = '"C:\temp"'

SELECT SQLHTTP.net.JsonEscape(@JsonValue)

----------------

\"C:\\temp\"