Why You Should Vote for My SQLRally Pre-Con
Self-marketing is not my strong suit. I don't feel very comfortable doing it, but Andy Warren (twitter | blog) suggests that we...
100 Years Ago, What Would You Be?
Today we have a guest editorial from Andy Warren asking what you might have done if you lived in the past.
An Example of Test-Driven Development
Developing a database can be an trying experience, and it's ways good to see how someone else builds a design. In this new article, MVP Andy Leonard shows us how to build a database using test-driven development for a weather database.
How to Import, Browse And Export Master Data Services' Data
Learn how to import data to Master Data Services (MDS) using Master Data Manager Portal UI to enter data manually or how to automate the import process by staging data into three different MDS staging tables.
SQL Server Connectivity Survey from Microsoft
A survey is available from the connectivity team at Microsoft that deals with ADO, ODBC, JDBC and more. Take the survey and help determine what is important for SQL Server.
Survey: what is the highest wait on your system?
SQL Server guru Paul Randal is conducting a short survey on wait states. Add your vote to the tally.
Worldwide Online TechDay/2010
Organized by Microsoft Brazilian Technical Community and relying on renowned international speakers, Worldwide Online TechDay/2010 promises to be the biggest technological online event ever seen. Oct 30, 2010
Protect the Excel files generated by SSIS package-Part I
It is not only the data within the database that requires protection but any report generated using SQL Server needs to be protected before being mailed
The Growth of Professional Development
Steve Jones talks about the more formal effort that it seems many people are placing to grow their careers.
SQL Rally: One Day on Query Performance Tuning
The SQLRally, a new PASS initiative taking place in the spring, is going to be a community driven event. This...
Blogs
SSMS Evaluation – future ready
By Vinay Thakur
In previous posts, we looked at the SQL Server engine. for us DBAs, the...
Claude.ai vs Claude API
By Arun Sirpal
You have used Claude. But which Claude? The Claude app (claude.ai, the desktop and...
T-SQL Tuesday #198–Change Detection
By Steve Jones
This month we have a new host, Meagan Longoria, who graciously agreed to help...
Forums
Alamat kontak resmi BCA KCU SUBANG Telp:0817-866-887
WhatsApp:0817866887 Jl. Otto Iskandardinata No.37, Karanganyar, Kec. Subang, Kabupaten Subang, Jawa Barat 41211
Alamat kontak resmi BCA KCU KELAPA GADING Telp:0817-866-887
WhatsApp:0817866887 Menara Satu Sentra Klp. Gading, Jl. Boulevard Bar. Raya No.1 Lt. Dasar, 1,...
Creating a JSON Document IV
Comments posted to this topic are about the item Creating a JSON Document IV
Question of the Day
Creating a JSON Document IV
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 YearEstablished, json_objectagg(city : TeamName) FROM dbo.NFLTeams GROUP BY YearEstablished;See possible answers