17 months of podcasting – recap
Before I publish the next episode of “Ask SQL Family” podcast, I would like to stop and look back for...
2019-01-23
147 reads
Before I publish the next episode of “Ask SQL Family” podcast, I would like to stop and look back for...
2019-01-23
147 reads
Hello folks! Good morning on Monday morning and let’s go through some interesting news from the #data world. Press Using...
2019-01-20
159 reads
Good morning chaps! Bunch of news from the world of data freshly served. Press Office Hours 2019/1/2 (With Transcriptions) The...
2019-01-13
186 reads
What popular tool has he created in 2006?
What popular tool has he created in 2006? How many people do live...
2019-01-11
183 reads
Azure Key Vault is a service which allows you to keep and manage passwords, certificates and other sensitive information securely....
2019-01-09
282 reads
Good morning chaps! Bunch of news from data’s world freshly served. Press Introduction to Testing Your PowerShell Code with Pester...
2019-01-06
163 reads
Good morning #sqlfamily folks! The very first post in the new year 2019. Tell me: when this time passed??? The...
2019-01-01
190 reads
The 2018 year is coming to the end. It’s a good time to review the passing year and… check whether...
2018-12-26
192 reads
The Christmas is coming. But before we start the festive time and sit down to the Christmas Eve dinner – a...
2018-12-23
183 reads
Hello data geeks. Last week we had many news about Cosmos DB, and this time the top topics are Power...
2018-12-16
180 reads
By HeyMo0sh
Microsoft Fabric (not to be confused with the more general term “fabric” in DevOps)...
By James Serra
I’m honored to be hosting T-SQL Tuesday — edition #192. For those who may...
By Vinay Thakur
Continuing from Day 2 , we learned introduction on Generative AI and Agentic AI,...
Hi Team, I am trying to refresh the Azure Synapse Dedicated pool from production...
hi everyone I am not sure how to write the query that will produce...
Comments posted to this topic are about the item Rollback vs. Roll Forward
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 *
FROM OPENJSON(
(
SELECT t.* FROM #test_data AS t FOR JSON PATH
)
) t; See possible answers