SQL Lunch One Year Anniversary
I am very excited to announce the 1 year anniversary of the SQL Lunch. Last year around this time I...
2010-10-04
421 reads
I am very excited to announce the 1 year anniversary of the SQL Lunch. Last year around this time I...
2010-10-04
421 reads
I have been working with a several clients that are leveraging Change Data Capture (CDC) as a tool for incrementally...
2010-10-03
1,341 reads
So many people have been waiting for a SQL Saturday in Houston and now it’s finally here. As a native...
2010-10-03
713 reads
I am not quite sure how many of you have tried to set or change the value of a variable...
2010-09-19
4,751 reads
Last Night (9/14/2010) I had the opportunity to present to the Wisconsin SQL Server User Group. My topic was SSIS-...
2010-09-15
523 reads
I was asked by someone the other day, where do you get your drive and motivation? For a second, I...
2010-09-06
648 reads
Puzzle #7 had an interesting twist. You were required to add a column to the result set that dynamically displayed...
2010-09-03
595 reads
Join me for Lunch - SQL Lunch #33 (Indicators, Sparklines and Databars)
#33-SSRS 2008 R2 - Indicators, Sparklines and Databars
Speaker: Patrick LeBlanc
Add To...
2010-08-30
1,696 reads
I have presented you with a couple of easy puzzles in the last few posts. So, let's step it up...
2010-08-29
477 reads
Puzzle #6 should not have presented too much of a challenge, it's intentions were to introduction you to the ORDER...
2010-08-27
490 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 Cilandak KKO HUB.Tlpn.0821•3111•185 Jl. Raya Cilandak / Margasatwa RT 006, RW 06...
Untuk menutup kartu kredit Bank UOB, Anda dapat menghubungi UOBCall melalui WhatsApp (6288220114008): atau...
BCA KCP Gudang Peluru Hub.0821•3111•185 Komp, Jl. Gudang Peluru Raya Jl. Kp. Melayu Besar...
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