SQLSaturday Schedule Changes
As will happen from time to time, we’ve had two changes on the schedule, wanted to make sure everyone catches...
2010-06-21
486 reads
As will happen from time to time, we’ve had two changes on the schedule, wanted to make sure everyone catches...
2010-06-21
486 reads
Yesterday I wrote about deciding to build a quick and dirty voting solution. Or to try to at least! Should...
2010-06-18
748 reads
The minutes of the June 2010 Board meeting have been posted and if you haven’t read them yet, you missed...
2010-06-18
670 reads
Last year for the annual Board of Directors election we used Zoomerang as our e-voting solution. It’s not the worst...
2010-06-17
516 reads
We had adjusted our meeting date to work around previous commitments for both Jack Corbett and I, and that may...
2010-06-17
543 reads
It’s been almost a month since my last update, too long! I’ve put up separate posts on my unplanned and...
2010-06-17
703 reads
Today we have a guest editorial from Andy Warren that looks at the value of experience.
2010-06-17
212 reads
Our most recent 24 Hours of PASS celebrated the SQL 2008 R2 launch. 24 great sessions, 23 of which were...
2010-06-16
586 reads
As the owner of a meeting/discussion you have two options on how to drive the conversation, and which you use...
2010-06-16
380 reads
We’re meeting from 6-8 pm as usual, with Kendal Van Dyke presenting Paging Dr Availability, You’re Wanted In the Recovery...
2010-06-15
312 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...
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,...
BCA KCP Pasar Minggu Center Telpon/wa:0813.7887.595.Jl. Lenteng Agung Raya No.26 E-F, Ps. Minggu, Kota...
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