MVP Status: Renewed
On October 1, 2016, I was first honored by Microsoft with their prestigious MVP award, given to those that they...
2018-07-10
216 reads
Ed
- Website: https://edleightondick.com
MVP Status: Renewed
On October 1, 2016, I was first honored by Microsoft with their prestigious MVP award, given to those that they feel have made a significant difference in their development...
2018-07-10
17 reads
MVP Status: Renewed
On October 1, 2016, I was first honored by Microsoft with their prestigious MVP award, given to those that they feel have made a significant difference in their development...
2018-07-10
6 reads
MVP Status: Renewed
On October 1, 2016, I was first honored by Microsoft with their prestigious MVP award, given to those that they feel have made a significant difference in their development...
2018-07-10
4 reads
MVP Status: Renewed
On October 1, 2016, I was first honored by Microsoft with their prestigious MVP award, given to those that they feel have made a significant difference in their development...
2018-07-10
5 reads
10 Years Young
It was early in 2009 – I don’t remember the date exactly. A group of us had gotten together after the...
2018-06-12
299 reads
10 Years Young
It was early in 2009 – I don’t remember the date exactly. A group of us had gotten together after the previous year’s PASS Summit and started I-380 PASS,...
2018-06-12
10 reads
10 Years Young
It was early in 2009 – I don’t remember the date exactly. A group of us had gotten together after the previous year’s PASS Summit and started I-380 PASS,...
2018-06-12
5 reads
10 Years Young
It was early in 2009 – I don’t remember the date exactly. A group of us had gotten together after the previous year’s PASS Summit and started I-380 PASS,...
2018-06-12
4 reads
10 Years Young
It was early in 2009 – I don’t remember the date exactly. A group of us had gotten together after the previous year’s PASS Summit and started I-380 PASS,...
2018-06-12
3 reads
Blogs
Cost Visibility: Tracking and Analysing Your Cloud Spend
By HeyMo0sh
One of the biggest challenges I’ve faced in cloud operations is maintaining clear visibility...
Whiling away an afternoon, thinking
By Steve Jones
I come to Heathrow often. Today is likely somewhere close to 60 trips to...
Black Box vs. Gray Box vs. White Box Testing
By Brian Kelley
If your organization is spending money, then meaningful results are a must. Pen testing...
Forums
Fun with JSON II
Comments posted to this topic are about the item Fun with JSON II
Changing Data Types
Comments posted to this topic are about the item Changing Data Types
Answering Questions On Dropped Columns
Comments posted to this topic are about the item Answering Questions On Dropped Columns
Question of the Day
Fun with JSON II
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