Sponsored Content
SQLServerCentral.com is always looking for ways that we can provide you with better, more useful content to help you learn about SQL Server. We've got a new idea and we're looking for feedback.
2007-11-12
394 reads
SQLServerCentral.com is always looking for ways that we can provide you with better, more useful content to help you learn about SQL Server. We've got a new idea and we're looking for feedback.
2007-11-12
394 reads
Is the rapid pace of information being fed to us a problem? Steve Jones has a few thoughts.
2007-11-12
41 reads
2007-11-08
49 reads
The growth of SQL Server's subsystems leaves Steve Jones wondering how should we be thinking about the product.
2007-11-07
125 reads
The SQL Server team is looking for feedback on deleting databases and Steve Jones gives a few ideas.
2007-11-06
104 reads
2007-11-05
48 reads
Had an interesting debate with Andy Warren on the tuning editorial today. I'm not sure we agree completely, but it's...
2007-11-05
706 reads
2007-11-05
755 reads
2007-11-02
2,809 reads
Or maybe C. I think the outside shooting shouldn't really count since that's "on location."
Someone asked me about the podcasts...
2007-11-01
652 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...
Jl. Bungur Besar Raya No.32 & 32A, Gn. Sahari Sel., Kec. Kemayoran, Kota Jakarta...
Ruko Atrium Blok E. 12-13, RW.2, Senen, Kec. Senen, Kota Jakarta Pusat, Daerah Khusus...
By Buka blokir bws mobile Bank Woori Saudara
Anda dapat menghubungi Call Center BWS melalui WhatsApp di (+62) 0817°0105°188, atau datang langsung...
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