Hemanth Damecharla

  • Interests: Operating Systems, Database Management Systems, Networks, Poetry.

Blogs

T-SQL Tuesday #198 Invitation: How Do You Detect Data Changes?

By

It's time for T-SQL Tuesday #198! This month's topic is change detection. The post T-SQL...

Understanding Fabric MCP

By

Model Context Protocol, or MCP, is one of those technical ideas that sounds more...

AWS RDS Aurora - our first approach

By

When starting with AWS RDS Aurora for managing relational databases in the cloud, many...

Read the latest Blogs

Forums

BCA KCP Abul Hasan TLP/WA 08216977701

By pinoyteleserye

Jl. KH. Abul Hasan No.8-9, Ps. Pagi, Kec. Samarinda Kota, Kota Samarinda, Kalimantan Timur...

BCA KCP Kas Segiri TLP/WA 08216977701

By pinoyteleserye

Jl. Lambung Mangkurat No.42B, RT.08, Pelita, Kec. Samarinda Ilir, Kota Samarinda, Kalimantan Timur 75117<!--more-->

BCA KCP Hidayatullah TLP/WA 08216366654

By pinoyteleserye

Jl. Pangeran Hidayatullah No.20, Karang Mumus, Kec. Samarinda Kota, Kota Samarinda, Kalimantan Timur 75113

Visit the forum

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      1960
If I run this code, how many rows are returned?
SELECT TOP 2 
  json_objectagg('Team' : TeamName)
FROM dbo.NFLTeams;

See possible answers