Logo Selected for SQLRally
Hopefully everyone saw the announcement already, either via the PASS Connector or the Twitter announcement, but we have – finally! – a...
2010-08-11
380 reads
Hopefully everyone saw the announcement already, either via the PASS Connector or the Twitter announcement, but we have – finally! – a...
2010-08-11
380 reads
The ‘Summit Preview’ edition, this time around it features speakers from the upcoming PASS Summit with each doing a one...
2010-08-11
339 reads
Consider this one a thinking out loud post more than most. We’ve had an explosion of speakers in the SQL...
2010-08-10
227 reads
MS just announced this publicly last week, it’s a Visual Studio product that seems to be geared towards the not-quite-developer...
2010-08-10
354 reads
Kendal Van Dyke blogged about it last week here, we ended up with 3 great designs to pick from for...
2010-08-09
332 reads
One of the things I think we don’t do well sometimes – in generally – is set fair expectations with regards to...
2010-08-09
655 reads
Over the course of my life I’ve lived in a few different places; small home, apartment, pup tent, large tent,...
2010-08-06
534 reads
Being a good mentor is hard, perhaps harder than being a parent, because with children it’s fair to share with...
2010-08-05
388 reads
In addition to being at at #40 as an attendee, I also had Don Gabor there to take a look...
2010-08-04
329 reads
Had a reasonably uneventful four drive to Miramar Friday, arriving in time to check in at the hotel and then...
2010-08-03
523 reads
By Vinay Thakur
Continuing from Day 3 where we covered LLM models open/closed and their parameters, Today...
By Steve Jones
One of the nice things about Flyway Desktop is that it helps you manage...
By HeyMo0sh
Microsoft Fabric (not to be confused with the more general term “fabric” in DevOps)...
I'm fairly certain I know the answer to this from digging into it yesterday,...
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...
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