amount decimal(7,2) '$.salesToDate.amount', currency nvarchar(3) '$.salesToDate.currency'); A more common scenario is to convert a JSON array into multiple rows in a related table. In my sample JSON ...

JSON arrays JSON arrays are an ordered list of values. Arrays are used to store objects, strings, number notation and Boolean notation. An array can be made up of multiple data types. Arrays in JSON ...