get all values separated by commas
How to get all values separated by commas, with only a SELECT query and a variable.
2012-07-19 (first published: 2012-07-03)
2,250 reads
How to get all values separated by commas, with only a SELECT query and a variable.
2012-07-19 (first published: 2012-07-03)
2,250 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...
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...
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