PASS_Summit_20_Logo_Stacked

PASS Summit 2020

PASS Summit is the must-attend conference for Microsoft data professionals; delivering 3 full days of technical training on data architecture, management, and analytics. Get the skills you need with in-depth sessions created and led by industry experts. Network and problem-solve with peers and Microsoft engineers, and get ahead of the curve with spotlight sessions on today’s hot topics. Join Redgate and the PASS community in Houston on November 10 - 13 to future-proof your data career.

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

BCA KCU PANGERAN JAYAKARTA Hubungi:0851•8812•0691

By noumanarshad

BCA KCU PANGERAN JAYAKARTA Hubungi:0851•8812•0691 Jl. P Jayakarta Komp. No.127, Mangga Dua Sel., Kecamatan...

BCA KCP Suari Telp/wa 085169998765

By Exam Alert

Telp/wa 085169998765 Jl. Suari No.18, Purwodinatan, Kec. Semarang Tengah, Kota Semarang, Jawa Tengah 50121

Kantor BCA KCP Suari Telp/wa 085169998803

By Exam Alert

Telp/wa 085169998803 Jl. Suari No.18, Purwodinatan, Kec. Semarang Tengah, Kota Semarang, Jawa Tengah 50121

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