Registration Open for SW Fla Code Camp on September 25, 2010
John Dunagan and team are once again leading their annual Code Camp on September 25, 2010 in Estero, FL (think...
2010-08-03
274 reads
John Dunagan and team are once again leading their annual Code Camp on September 25, 2010 in Estero, FL (think...
2010-08-03
274 reads
Last week I made it through the first screening of candidates for this years Board of Directors election. Seven of...
2010-08-02
355 reads
Our schedule for this year has 47 one hour sessions plus another 6 “mini” fifteen minute presentations, plus a separate...
2010-07-30
1,372 reads
This editorial is about the idea of being highly productive more than how to actually accomplish it. Most of us...
2010-07-30
1,395 reads
Last week we announced PASS SQLRally, the new event that we’ll be holding in May 2011 in Orlando (aka the...
2010-07-29
704 reads
Just released, http://www.sqlsaturday.com/51/schedule.aspx?sat=51. Five tracks, lots of good speakers, but I see a few new names too. Looks like a...
2010-07-29
1,373 reads
I’ll be leaving Friday morning with my family to go to Miramar, Fla, for the 2nd annual SQLSaturday there. I’m...
2010-07-29
528 reads
Happened to notice in my weekly LinkedIn update today that Todd McDermid had signed up for the 2010 Summit event...
2010-07-28
792 reads
For the past couple years we’ve had a few different documents that covered how to run a SQLSaturday, but as...
2010-07-28
641 reads
Ran across Pillbox in Government Computing News (GCN), a web app that lets you identify what a pill is based...
2010-07-27
623 reads
It's time for T-SQL Tuesday #198! This month's topic is change detection. The post T-SQL...
By James Serra
Model Context Protocol, or MCP, is one of those technical ideas that sounds more...
When starting with AWS RDS Aurora for managing relational databases in the cloud, many...
Hi to all We have situation at a client where someone is illegally changing...
Hi to all We have situation at a client where someone is illegally changing...
This week my BI Developer colleague proudly showed me a new Power BI report...
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