Results of PASS Summit 2010 Content Survey Released
A few weeks back PASS sent out a survey to get input on how to shape the 2010 Summit agenda,...
2010-04-22
537 reads
A few weeks back PASS sent out a survey to get input on how to shape the 2010 Summit agenda,...
2010-04-22
537 reads
Most of us have some general rules we live by, and I’ve often thought it would be a lot easier...
2010-04-21
727 reads
We just put the site up, starting a little earlier than last year, and over the course of this week...
2010-04-21
499 reads
Found Ninite while browsing a list of efficiency tools on PCWorld.com. It’s a one stop super installer, you run through...
2010-04-20
626 reads
I’ve had this on my list to write about for a while, just didn’t have a great example until this...
2010-04-19
498 reads
I hear that registration is over 350 so far, with seats still available – but register soon! I’m driving up with...
2010-04-19
507 reads
First, some background. If you’ve been to the Summit you know that we have an opening night reception, lots of...
2010-04-16
1,119 reads
A few weeks back I was in Chicago for three days for work. I’ve been through the airport a couple...
2010-04-16
954 reads
I’ve been waiting on this for a while, and missed the announcement that it was available, happened to see that...
2010-04-15
545 reads
SQLSaturday #38 is coming up on May 8th, 2010, back at the same location as in previous years at the...
2010-04-15
492 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