Giving Thanks
I came across a blog post today from Jason Strate (Blog | Twitter) about giving thanks. This topic has come about...
2010-11-23
866 reads
I came across a blog post today from Jason Strate (Blog | Twitter) about giving thanks. This topic has come about...
2010-11-23
866 reads
I came across a blog post today from Jason Strate (Blog | Twitter) about giving thanks. This topic has come about due to the holiday in the United States...
2010-11-23
6 reads
It is down to the final two chapters of the book by Alex Kuznetsova. Check out the previous chapter here....
2010-11-22
964 reads
It is down to the final two chapters of the book by Alex Kuznetsova. Check out the previous chapter here. The review of this book is certainly taking longer...
2010-11-22
4 reads
We are slowly getting to the end of this book by Alex Kuznetsov (Blog). You can find more on this...
2010-11-11
548 reads
We are slowly getting to the end of this book by Alex Kuznetsov (Blog). You can find more on this series by looking here. We are now discussing chapter 8...
2010-11-11
4 reads
A few days ago I wrote about an election that was taking place (ok so it was a week ago...
2010-11-10
569 reads
A few days ago I wrote about an election that was taking place (ok so it was a week ago at this point). That election was the SQLServerpedia Awards....
2010-11-10
4 reads
Last Thursday we had the monthly meeting for our local PASS chapter. I would normally try to get the recap...
2010-11-09
499 reads
Last Thursday we had the monthly meeting for our local PASS chapter. I would normally try to get the recap out a bit sooner. This month, I intentionally delayed...
2010-11-09
3 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 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
Comments posted to this topic are about the item Foreign Keys - Foes or...
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