Skip to content

TSQL Function to Split JSON Data

SQL Server Central has a great function that converts a JSON string into a table. Worth checking out! (Unfortunately you have to register to see it, but it’s free.)

Function looks like this

-- object example, braces surround the name:value objects 
SELECT id, name, value FROM

Which returns a table:

id	name	    value
1	Apples	    20000
2	Oranges	    400
3	Apricots    507

Dan View All

Blog owner.

%d bloggers like this: