In that earlier column, I looked at why you might want to do that and handled the simple case: Converting single-value properties in a JSON object into a row in a table (or multiple rows where you ...

allows me to convert the string-value date in the object into a genuine SQL Server date. This SQL statement extracts the id and createdOn properties from my JSON object (and creates a row with columns ...