2013-10-02
2,889 reads
- Interests: Answering Complex Questions
2013-09-25
3,007 reads
2013-09-24
3,016 reads
2013-09-16
2,803 reads
2012-11-30
2,418 reads
2012-08-15
3,019 reads
2012-07-12
2,944 reads
2012-07-10
3,254 reads
Blogs
T-SQL Tuesday #198 Invitation: How Do You Detect Data Changes?
It's time for T-SQL Tuesday #198! This month's topic is change detection. The post T-SQL...
Understanding Fabric MCP
By James Serra
Model Context Protocol, or MCP, is one of those technical ideas that sounds more...
AWS RDS Aurora - our first approach
When starting with AWS RDS Aurora for managing relational databases in the cloud, many...
Forums
BCA KCP Kas PIK II TLP/WA 08216977749
Rukan Ekslusif Bukit Golf Mediterania, Pantai Indah Kapuk St No.17 Blok C, RT.7/RW.2, Kamal...
BCA KCP Ancol TLP/WA 08216977749
Blok A VI No, Jl. Parang Tritis Raya 3B-3C, Ancol, Kec. Pademangan, Jkt Utara,...
BCA KCP Puri Deltamas Tlp/Wa 08216977749
Komplek Ruko Puri Deltamas Blok J. 5, Jl. Bandengan Sel. No.43, Daerah Khusus Ibukota...
Question of the Day
Creating a JSON Document III
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