synapse

SQLServerCentral Article

You rated this post out of 5. Change rating

2026-02-16 (first published: )

12,979 reads

Blogs

PlanTrace: Stop Reading Redshift EXPLAIN Plans. Start Seeing Them

By

PlanTrace: Stop Reading Redshift EXPLAIN Plans. Start Seeing Them Introducing PlanTrace — a free, browser-based...

A Cloud Dependency Failure from Amazon

By

I went to sleep while reading a Kindle book on my phone. I know...

Deploying AI in logistics (the unfiltered version)

By

A conversation with Jan Laš, CIO at HOPI, about what deploying a data agent...

Read the latest Blogs

Forums

Berikut ini cara mengatasi masalah lupa username( permata bank )

By jeksen

Cara buka blokir Bank Permata (rekening/ATM/mobile) dapat dilakukan melalui PermataTel di 1500-111, whatsapp, 0821"...

BCA KCP Pettarani Hub/Wa (08218573837)

By Nhà Cái OneBox63

Kompleks Perkantoran Pettarani, Jl. AP. Pettarani No.18, Tamamaung, Kec. Panakkukang, Kota Makassar, Sulawesi Selatan...

BCA KCP Senen Telpon/wa:0813.7887.595

By bomchuachay34

BCA KCP Senen Telpon/wa:0813.7887.595.Pusat Grosir Senen Jaya Blok A8-9, Lantai 2, RW.3, Senen, Kec....

Visit the forum

Question of the Day

Creating a JSON Document III

I have this data in a table called dbo.NFLTeams

TeamID  TeamName       City             YearEstablished
------  --------       ----             ---------------
1       Cowboys        Dallas           1960
2       Eagles         Philadelphia     1933
3       Packers        Green Bay        1919
4       Chiefs         Kansas City      1960
5       49ers          San Francisco    1946
6       Broncos        Denver           1960
7       Seahawks       Seattle          1976
8       Patriots       New England      1960
If I run this code, how many rows are returned?
SELECT TOP 2 
  json_objectagg('Team' : TeamName)
FROM dbo.NFLTeams;

See possible answers