JSON Archives - Page 7 of 7 - SQL Authority with Pinal Dave

An old paraffin lamp beside a new rechargeable lantern on a porch step

T-SQL Features Added in Recent Versions

June 5, 2011

Compatibility Level, JSON, SQL Function, SQL Server, SQL Server 2022

T-SQL features added in recent SQL Server versions shorten common date, comparison, string, and JSON patterns when deployed deliberately.

A hand working a sorting gate at a sheep pen, holding back one red-marked sheep

Validating JSON Parameters Before a Procedure Uses Them

October 23, 2009

Pinal Dave

SQL Tips and Tricks

Best Practices, JSON, SQL Server, SQL Stored Procedure

Learn validating JSON parameters before changing data with ISJSON, JSON_PATH_EXISTS, TRY_CAST, and a single clear list of input errors.

A clear tumbler and a corked glass bottle with a sage ribbon on warm paper.

STRING_ESCAPE JSON Text: Escaping Is Not Serialization

May 20, 2008

Pinal Dave

SQL Tips and Tricks

JSON, SQL Function, SQL Server, SQL String

STRING_ESCAPE JSON text is still text that belongs inside a JSON string. This example compares quotations, backslashes and a newline with complete FOR JSON PATH objects.