I’m Attending the South Florida Code Camp on February 27, 2010
I’m driving down tomorrow for the sixth annual South Florida Code Camp. This will be my third time attending and...
2010-02-25
524 reads
I’m driving down tomorrow for the sixth annual South Florida Code Camp. This will be my third time attending and...
2010-02-25
524 reads
If you’ve been around SQL for any length of time it’s hard not to have heard of Brad McGehee, the...
2010-02-24
566 reads
I’m in the early stages of a book on managing and I’m starting to look for situations that might trigger...
2010-02-23
1,100 reads
This happened earlier in the year, finally getting around to writing some notes on it – you can read more here....
2010-02-22
733 reads
Ran across this in Make Magazine, http://www.bigkidbike.com/, these are totally custom bikes, with names like Bigger Wheel, Lizard, and Kitten....
2010-02-19
551 reads
I’m in Chicago for a couple days next week, flying in on Sunday. Anyone in the area available for dinner...
2010-02-18
541 reads
Joe Healy is doing a four hour Azure training event on March 6, 2010 in Orlando, details and free registration...
2010-02-18
663 reads
My friend Jack posted a nice aggregate of comments so far about the transfer of SQLSaturday to PASS, and added...
2010-02-18
550 reads
Found The Adversity Index while browsing and thought I’d share. It’s interesting to see the economic trends and I’ll let...
2010-02-18
501 reads
Today we have a guest editorial from Andy Warren. Balancing work and life is a challenge, and today Andy looks at one way that has helped him to manage his hours and learn to get away from work.
2010-02-18
117 reads
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...
It's time for T-SQL Tuesday #198! This month's topic is change detection. The post T-SQL...
Jl. Kramat Kwitang No.29, Kwitang, Kec. Senen, Kota Jakarta Pusat, Daerah Khusus Ibukota Jakarta...
Jl. Percetakan Negara II No.16 B-C, RT.3/RW.3, Johar Baru, Kec. Johar Baru, Kota Jakarta...
Jl. K.H. Wahid Hasyim No.82, Kb. Sirih, Kec. Menteng, Kota Jakarta Pusat, 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