The Vacation Backlash
Maybe I need a better name for it, but I’m describing the pain that happens when you’re getting ready for...
2010-07-26
589 reads
Maybe I need a better name for it, but I’m describing the pain that happens when you’re getting ready for...
2010-07-26
589 reads
Victorious by Jack Campbell ($8 at Amazon) is the finale in the six part series about Black Jack Geary leading...
2010-07-23
682 reads
Kendal posted the announcement yesterday that we opened the design content on 99designs. I’ve used the site before and it’s...
2010-07-23
573 reads
Over the past couple years our local library system has been under financial pressure, resulting in some changes, and maybe...
2010-07-22
988 reads
Today we have a guest editorial from Andy Warren. You can get more productive, but are you being productive at the tasks that you should be working on? See what Andy Warren has to say.
2010-07-21
256 reads
A bit of a silly title, but an interesting story. A few weeks back I posted a note about attending...
2010-07-21
605 reads
I saw this post (please do read it) about introducing speakers and it reminded me that I wanted to write...
2010-07-20
547 reads
We’ve had a few people in the SQL community find jobs lately and many of them attributable to their network....
2010-07-19
518 reads
I recently read Rework by Jason Fried of 37 Signals ($13 @ Amazon) and it talks about a lot of philosophy...
2010-07-16
541 reads
You can still submit abstracts through midnight tonight for SQLSaturday #49 in Orlando on October 16, 2010. Great time of...
2010-07-16
881 reads
By Vinay Thakur
Continuing from Day 4 where we learned Encoder, Decoder, and Attention Mechanism, today we...
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...
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