2020-10-11
16 reads
2020-10-11
16 reads
2020-10-11
20 reads
With all the stuff going on around the world over the last year, maintaining some degree of mental stability can be quite a challenge. Speaking only for myself, while...
2020-10-09 (first published: 2020-10-05)
358 reads
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2020-10-09
13 reads
I want PASS to survive. I can say that unequivocally, because this organization has been a part of my career, my job, and my life for twenty years. Many...
2020-10-09 (first published: 2020-09-29)
424 reads
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2020-10-08
12 reads
Microsoft Ignite has always announced many new products and new product features, and this year was no exception. Many exciting announcements, and below I list the major data platform related...
2020-10-08 (first published: 2020-09-30)
492 reads
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. Recently I was looking through the forums and...
2020-10-08 (first published: 2020-09-30)
397 reads
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2020-10-07
21 reads
I’ve had to do some work on PostgreSQL, and I wrote an article at SQLServerCentral about getting started. Once I had things working, and could connect from Azure Data...
2020-10-07
158 reads
By Vinay Thakur
These days everything is changing to AI World, IT roles are getting changed and...
PlanTrace: Stop Reading Redshift EXPLAIN Plans. Start Seeing Them Introducing PlanTrace — a free, browser-based...
By Steve Jones
I went to sleep while reading a Kindle book on my phone. I know...
Jl. Cibinong City Center No.5 Ruko Blok A, Pakansari, Kec. Cibinong, Kabupaten Bogor, Jawa...
Ruko Cilegon City Square, Jl. Pondok Cilegon Indah No.1 Blok A No. 1-3 &...
Jl. Raya Merak No.42, Ramanuju, Kec. Purwakarta, Kota Cilegon, DKI Jakarta 42411
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 1960If I run this code, how many rows are returned?
SELECT TOP 2
json_objectagg('Team' : TeamName)
FROM dbo.NFLTeams;
See possible answers