Speaking at SQLSaturday #7 in Birmingham on May 30, 2009
I'm flying up Friday afternoon to participate in SQLSaturday #7 which is being led by John Baldwin and his team...
2009-05-26
1,350 reads
I'm flying up Friday afternoon to participate in SQLSaturday #7 which is being led by John Baldwin and his team...
2009-05-26
1,350 reads
Wes is a friend acquiring via networking and community involvement - another success story! He's based in Tampa and has been...
2009-05-25
560 reads
I've been using Snarfer for a while now, preferring an offline reader so that I use a few spare moments...
2009-05-25
739 reads
I just finished up my third coaching call with Don Gabor (Part 1, Part 2, Part 3, Part 4) and I think I'm gaining a little ground, but still finding that I have a lot to learn.
2009-05-25
813 reads
Today in the United States we celebrate Memorial Day, the day we remember American casualties of any military action. Though...
2009-05-24
558 reads
The Making of the Atomic Bomb by Richard Rhodes ($14 at Amazon) was a book I picked up for travel,...
2009-05-21
672 reads
I've been reading What Got You Here Won't Get You There by Marshall Goldsmith over the past couple months, and found it to be a useful book. My one sentence summary is that it teaches without the ability to be introspective and let go of your pride,...
2009-05-21
1,793 reads
I currently write the editorial for the PASS Connector which is published every two weeks as part of my role...
2009-05-20
600 reads
I just finished up my third coaching call with Don Gabor (Part 1, Part 2, Part 3, Part 4) and...
2009-05-20
665 reads
I currently write the editorial for the PASS Connector which is published every two weeks as part of my role...
2009-05-19
739 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...
Looking for a creative and experienced mobile game development company that brings your game...
hi everyone I am not sure how to write the query that will produce...
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