PASS Update #26 (Bylaws & Upcoming Board Meeting)
Most months we do a conference call, but a couple times a year we get to meet in person and...
2010-03-16
597 reads
Most months we do a conference call, but a couple times a year we get to meet in person and...
2010-03-16
597 reads
It’s pretty common to download software as an ISO file (a disk image) and it seems like a waste to...
2010-03-15
781 reads
My wife and I try to have dinner out every other week or so, but we tend to fall into...
2010-03-12
769 reads
I’ll be attending and speaking at the Orlando Code Camp on March 27, 2010 at Seminole State College along with...
2010-03-12
554 reads
By now you’ve probably seen the official announcement from PASS about the Summit being located in Seattle for both 2011...
2010-03-11
675 reads
I’m in charge of networking and social time for oPASS and I do what I can to help get our...
2010-03-11
508 reads
We put this together last year and we’re up to 270 blogs listed, but I’m sure we’re still missing some,...
2010-03-10
512 reads
Saw this article about more elbow room, the premise being that is it is often cheaper to buy a second...
2010-03-09
352 reads
I did the relatively quick flight to Charlotte on Friday afternoon, arriving just before 2 pm, grabbed lunch to go...
2010-03-08
301 reads
I’m flying up Friday afternoon for SQLSaturday #33. Looking forward to the trip, Charlotte is a great area and I...
2010-03-05
392 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...
We suffered a SPAM attack from May 1-6, which unfortunately corresponded with time off...
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...
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