Blog Posts

Blog Post

Dipping into the Cookie Jar

This post is a response to this month's T-SQL Tuesday #112 prompt by Shane O'Neill.  T-SQL Tuesday is a way for the SQL Server community to share ideas about different database and...

2019-03-12

3 reads

Blog Post

Dipping into the Cookie Jar

This post is a response to this month's T-SQL Tuesday #112 prompt by Shane O'Neill.  T-SQL Tuesday is a way for the SQL Server community to share ideas about different database and...

2019-03-12

2 reads

Blogs

Future IT Roles – Agentic Architect and AI Boom!!

By

These days everything is changing to AI World, IT roles are getting changed and...

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...

Read the latest Blogs

Forums

BCA KCP Kramat Jati Hub.0851•8812•0691

By johnkavita

BCA KCP Kramat Jati Hub.0851•8812•0691 Jl. Raya Bogor No.19, RT.1/RW.4, Wil, Kec. Kramat jati,...

BCA KCU MUARA KARANG Hub.0851•8812•0691

By johnkavita

BCA KCU MUARA KARANG Hub.0851•8812•0691 Jl. Muara Karang Timur, Blok B VIII No.116-117, Daerah...

BCA KCP Kramat Jaya Baru Hub.0851•8812•0691

By johnkavita

BCA KCP Kramat Jaya Baru Hub.0851•8812•0691 Jl. Percetakan Negara II No.16 B-C, RT.3/RW.3, Johar...

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