XML-XSL Transformations in SQL Server
With the release of Master Data Services (MDS) for SQL Server 2008R2, it is now possible to perform XML transformations on the database server.
2012-01-04
7,775 reads
Cem Güler
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 Multifinance Cabang Kedoya Tlpn.Wa 083834802131
Citta Graha, Jl. Panjang, RT.5/RW.1, South Kedoya, Kebonjeruk, West Jakarta City, Jakarta 11520
BCA KCP Pasar Minggu Center tlpn/wa: (0831)10703017
BCA KCP Pasar Minggu Center tlpn/wa: (0831)10703017 Jl. Lenteng Agung Raya No.26 E-F, Ps. Minggu,...
BCA KCP Kopo TLP/WA 08216366654
Jl. Raya Kopo No.26 A-B, Panjunan, Kec. Astanaanyar, Kota Bandung, Jawa Barat 40242
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