Travel for 2010
Lately I’ve been thinking that I need to try harder to focus on doing the things I both want to...
2009-09-23
574 reads
Lately I’ve been thinking that I need to try harder to focus on doing the things I both want to...
2009-09-23
574 reads
Since the beginning of the year I’ve been trying to include a SQL related book in the bi-weekly Connector. Basically...
2009-09-22
550 reads
I currently write the editorial for the PASS Connector which is published every two weeks as part of my role...
2009-09-22
561 reads
I’ve written here and there about my attempts at time management and the idea that as you spin more and...
2009-09-21
603 reads
Just received a note from Dave Noderer that the 2010 South Fla Code Camp will be February 13th in Mirarmar,...
2009-09-21
531 reads
My friend Kevin had sent this to me after I wrote The Boss Is Always Right but before it was...
2009-09-20
701 reads
I’ve been on the board just about 8-1/2 months, so I’m not doing too bad on updates, but think I’ll...
2009-09-18
1,080 reads
Last week I posted Part 1 and Steve Jones gave some grief about not posting some pictures (rightfully so) of...
2009-09-17
835 reads
Bet you’re ready to disagree, right? I’ve had this on my list to write about for a while. One trend...
2009-09-17
1,355 reads
Simon is a prolific blogger, at rough look averaging 10-15 posts per month, and almost all of them are SQL,...
2009-09-16
793 reads
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...
A conversation with Jan Laš, CIO at HOPI, about what deploying a data agent...
Jl. Kemanggisan Utama Raya No.37, Kemanggisan, Kec. Palmerah, Kota Jakarta Barat, Daerah Khusus Ibukota...
Komp. Bojong Indah Cengkareng, Jl. Pakis Raya 88 H, Daerah Khusus Ibukota Jakarta 11740
Jl. Mandala Raya No.14, RT.13/RW.5, Tomang, Kec. Grogol petamburan, Kota Jakarta Barat, Daerah Khusus...
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