Got Any Grapes?
This past weekend we took a mini vacation, along the way my daughter decided to play this song, which is...
2013-05-14
600 reads
This past weekend we took a mini vacation, along the way my daughter decided to play this song, which is...
2013-05-14
600 reads
It’s not uncommon to get frustrated about something at work and send out an email blasting whatever person or group...
2013-05-10
706 reads
I read quite a bit and it’s rare that I don’t have a book or magazine with me in case...
2013-05-07
677 reads
Recently at work we had a “Hawaiian Shirt Day”, a nice change from the usual business casual. I picked one...
2013-05-06
582 reads
For the past couple months I’ve been looking forward to a 5 week break, a chance to think about what...
2013-04-30
1,406 reads
As I re-read the original Looking Back post I realized I didn’t include anything about the fear part – stepping away...
2013-04-29
1,254 reads
Spend a few minutes reviewing 20 Critical Security Controls. Very interesting stuff. For example, #1 refers to having and maintaining...
2013-04-27
809 reads
In July 2011 I took what felt like a big chance and a detour to lead a large and complex...
2013-04-24
731 reads
The Way, starring Martin Sheen and directed by Emilio Estevez has been on my want to watch list for a...
2013-04-23
675 reads
I’ll be attending and presenting at SQLSaturday #200 in Philadelphia in June, then I’ll be attending the first ever SQLSaturday...
2013-04-22
650 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