PreCon Sessions at the PASS Summit
My friend Andy Leonard posted yesterday about the process of getting selected for one of the coveted slots as a...
2010-06-01
388 reads
My friend Andy Leonard posted yesterday about the process of getting selected for one of the coveted slots as a...
2010-06-01
388 reads
The Yankee Years by Joe Torre ($12 @ Amazon) was a gift, and I enjoyed it more than expected. When it...
2010-05-28
1,407 reads
Today we have a guest editorial from Andy Warren that asks about your hobbies, and would you trade your job for one of them?
2010-05-28
164 reads
Here are the results of the survey, 75% in favor of a non-technical keynote, with a less than stellar sampling...
2010-05-27
622 reads
Last week I wrote an editorial for SQLServerCentral titled Does The Job Matter To You?, asking how much the type...
2010-05-25
557 reads
I’ve just finished handing over the source code for all the SQLSaturday related items after finishing up a couple minor...
2010-05-24
491 reads
I ordered a copy of Currencies That Buy Credibility ($14 @ Amazon) after a comment from author Tom Wanek on Twitter...
2010-05-21
543 reads
If you download the May 2010 minutes of the Board meeting (login required) you’ll see that we devoted an entire...
2010-05-21
590 reads
How important is your job to you? Today's guest editorial from Andy Warren asks the question of the professionals out there, some of whom do great work, but don't care about their jobs.
2010-05-20
307 reads
We’re still in the early stages so the pace is comfortably slow. We’ve got about 30 sessions in already (plenty...
2010-05-20
518 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. Raya Prapen No.38, Sidosermo, Kec. Wonocolo, Surabaya, Jawa Timur 60299
BCA KCP Tebet Barat Telpon/wa:0813.7887.595.Jl. Tebet Barat IX No.40, Tebet Bar., Kec. Tebet, Kota...
Tunjungan Plaza 6, Pakuwon Tower Jl. Embong Malang No.21-31 Level Lower Ground Unit 01,...
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