XML Attribute VS Element Assignment when working with SQL
XML handling with aliases
I find it interesting the difference in behavior with querying XML between column assignment, and quoted alias...
2015-09-21
305 reads
Sheldon Hull
- Website: https://www.sheldonhull.com
XML Attribute VS Element Assignment when working with SQL
XML handling with aliases
I find it interesting the difference in behavior with querying XML between column assignment, and quoted alias...
2015-09-21
195 reads
Split personality text editing in SSMS with Sublime Text 3
Split personality text editing in SSMS with Sublime Text 3
My preview post showed a demonstration of the multi-cursor editing power...
2015-09-14
202 reads
Split personality text editing in SSMS with Sublime Text 3
Split personality text editing in SSMS with Sublime Text 3
My preview post showed a demonstration of the multi-cursor editing power...
2015-09-14
1,097 reads
Multi-Cursor Editing SQL feels like the movie Inception just became real
Yes… multicursor editing is epic No… SSMS doesn’t support multi-cursor editing the way it should. Yes… you can do some...
2015-09-10
2,343 reads
Multi-Cursor Editing SQL feels like the movie Inception just became real
- Yes… multicursor editing is epic
- No… SSMS doesn’t support multi-cursor editing the way it should.
- Yes… you can do some...
2015-09-09
164 reads
Brentozar’s Training: Chocolate & Cowboy Hats Included
It was entertaining to listen to a technical wizard fighting the obsession with waiting to eat chocolate with 3k viewers...
2015-08-27
309 reads
Brentozar's Training: Chocolate & Cowboy Hats Included
It was entertaining to listen to a technical wizard fighting the obsession with waiting to eat chocolate with 3k viewers...
2015-08-27
205 reads
Monitoring SQL Server on a budget
Monitoring SQL Server on a budget
Cheap ain’t easy
There’s a lot of tools out there, and very few that are polished,...
2015-08-18
319 reads
Monitoring SQL Server on a budget
Monitoring SQL Server on a budget
Cheap ain’t easy
There’s a lot of tools out there, and very few that are polished,...
2015-08-18
399 reads
Blogs
PlanTrace: Stop Reading Redshift EXPLAIN Plans. Start Seeing Them
PlanTrace: Stop Reading Redshift EXPLAIN Plans. Start Seeing Them Introducing PlanTrace — a free, browser-based...
A Cloud Dependency Failure from Amazon
By Steve Jones
I went to sleep while reading a Kindle book on my phone. I know...
Deploying AI in logistics (the unfiltered version)
A conversation with Jan Laš, CIO at HOPI, about what deploying a data agent...
Forums
BCA Finance Bekasi Layanan Mobil Hub.0853•5504•2311
BCA Finance Bekasi Layanan Mobil Hub.0853•5504•2311 KOMPLEK MEGA OFFICE PARK, Jl. Harapan Indah Boulevard...
BCA Finance - Depok Hub.0851•8812•0691
BCA Finance - Depok Hub.0851•8812•0691 Komplek Perkantoran, Ruko Pesona View, Jl. Pesona Khayangan Jl....
BCA Finance WTC Mangga Dua HUB.Tlpn.0821•3111•185
BCA Finance WTC Mangga Dua Hub.0821•3111•185 Gedung WTC Jl. Mangga Dua Raya. 8 Lantai...
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