JSON

SQLServerCentral Article

Fun with JSON

  • Article

Last year, I used a lot of JSON to exchange data between systems. There are several ways to extract data from a JSON file, but there is one specific, probably less-used possibility that I’d like to highlight. For one project, I received JSON files containing a variable number of parameters and their values. If I […]

(4)

You rated this post out of 5. Change rating

2026-03-09 (first published: )

4,168 reads

External Article

SQL Server JSON Functions JSON_OBJECTAGG and JSON_ARRAYAGG

  • Article

I need to construct JSON from data in our database, but I find the existing FOR JSON PATH limited when the data is not located in one single row but rather scattered over multiple rows. Is there another method on how to handle JSON data in SQL Server? Learn how to use the new SQL Server JSON Functions JSON_OBJECTAGG and JSON_ARRAYAGG in this article.

2025-03-24

Blogs

Finding Balance: Things Will Come Up

By

I have a presentation on finding balance in your career that got quite a...

Who Are You Doing It For?

By

But as I've matured over the years, I came to realize that I needed...

Presenting Twice in May 2026

By

I will be presenting my latest session, Documenting Your Work for Worry-Free Vacations, in-person...

Read the latest Blogs

Forums

degree of parallelism

By Davekahn

Team, I'm trying to figure out what will be the best recommendation to configure...

A Fun Computer Quote

By Steve Jones - SSC Editor

Comments posted to this topic are about the item A Fun Computer Quote

AI Database Central

By Steve Jones - SSC Editor

Comments posted to this topic are about the item AI Database Central

Visit the forum

Question of the Day

A Fun Computer Quote

Which movie featured this quote?

"All programs have a desire to be useful."
Happy April Fools!

See possible answers