I have been working in various computer languages for a long time. When I saw that the || operator was coming, I was a bit confused as to why we needed this, and how it would work. After all, this is a part of other languages. I decided to dig in a bit. This is […]
2025-12-19
8,458 reads
2025-12-19
591 reads
Today Steve asks what value you get from attending conferences or other events.
2025-12-19
44 reads
2025-12-17
608 reads
Steve sees a lot of challenges ahead for AI, especially in the area of labor and employment.
2025-12-17
82 reads
2025-12-15
1,364 reads
This week Steve Jones discusses artificial intelligence and one of the building blocks that will be needed: data.
2025-12-15 (first published: 2016-07-04)
190 reads
Superheroes and saints never make art. Only imperfect beings can make art because art begins in what is broken – from Excellent Advice for Living Interesting advice for living...
2025-12-12
12 reads
Refactoring code is a common task in many software development teams. Steve asks if this is something common for database developers as well.
2025-12-12
257 reads
Steve looks to the future of Microsoft and AI after listening to a podcast with Satya Nadella
2025-12-10
120 reads
By Steve Jones
Finding duplicates was an interview question for me years ago, and I’ve never forgotten...
By HeyMo0sh
Over time, I’ve realised that one of the hardest parts of cloud management isn’t...
By HeyMo0sh
One of the biggest challenges I’ve faced in cloud operations is maintaining clear visibility...
Comments posted to this topic are about the item Fun with JSON II
Comments posted to this topic are about the item Changing Data Types
Comments posted to this topic are about the item Answering Questions On Dropped Columns
I have some data in a table:
CREATE TABLE #test_data
(
id INT PRIMARY KEY,
name VARCHAR(100),
birth_date DATE
);
-- Step 2: Insert rows
INSERT INTO #test_data
VALUES
(1, 'Olivia', '2025-01-05'),
(2, 'Emma', '2025-03-02'),
(3, 'Liam', '2025-11-15'),
(4, 'Noah', '2025-12-22');
If I run this query, how many rows are returned?
SELECT t1.[key] AS row,
t2.*
FROM OPENJSON(
(
SELECT t.* FROM #test_data AS t FOR JSON PATH
)
) t1
CROSS APPLY OPENJSON(t1.value) t2; See possible answers