Working with various Flyway configuration options used to be a pain since they were either CLI parameters or in a text files. We’ve made editing these easier in Flyway...
2023-09-29 (first published: 2023-08-25)
141 reads
2023-09-27
355 reads
The way we view our jobs might change how we do them. Steve has some advice on how to think about the work you do.
2023-09-27
109 reads
Many people are worried for their future career prospects with the growth of Artificial Intelligence (AI) in many situations. Steve doesn't think that AI is going to take over the world, but it might affect your future opportunities.
2023-09-25
155 reads
The Future Data Driven 2023 virtual conference is coming on Wednesday, September 27. Register today and save a note in your calendar. The event has a great schedule (scroll...
2023-09-25
15 reads
A few years ago SQL Prompt added a command palette to let you search the commands available. This is similar to the same concept in Visual Studio Code, ADS,...
2023-09-25
74 reads
One of the things that I feel is important to building better software is testing your code. It should be easy and simple to test code and determine if...
2023-09-25 (first published: 2023-08-28)
376 reads
My slides are here: VCS Primer Denver 2023 This was an overview of what version control is, and the basics of Git. Not too many questions, but if you...
2023-09-25
16 reads
2023-09-25
469 reads
wildred –adj. feeling the haunting solitude of extremely remote places – a clearing in the forest, a windswept field of snow, a rest area in the middle of nowhere...
2023-09-22
13 reads
By HeyMo0sh
Working in DevOps long enough teaches you two universal truths: That’s exactly why I...
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...
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