Word Up
A short post today. For a while I've been subscribing to the Word of the Day from Merriam-Webster (free) and...
2009-02-11
620 reads
A short post today. For a while I've been subscribing to the Word of the Day from Merriam-Webster (free) and...
2009-02-11
620 reads
We'll be announcing this on the main www.sqlpass.org site and the PASS blog over the next day or two, but...
2009-02-10
1,219 reads
A mildly humorous title, spawned by a link my friend Jon sent me about calculating Pi using a batch file....
2009-02-10
779 reads
Last week I posted Update #3 that discussed my first board meeting, but I didn't have time to cover my goals, so I 'll do that and add some other minor items as well.
2009-02-10
968 reads
As I mentioned last week I drove to Miramar for the South Florida Code Camp, arriving in time for the...
2009-02-09
523 reads
Forwarding on a note from my local MS Developer Evangelist Joe Healy about his next series of free presentations coming...
2009-02-08
771 reads
Last week I posted Speaking at Community Events - Time to Raise the Bar?, a first cut at talking about to...
2009-02-08
1,266 reads
Last week I posted Update #3 that discussed my first board meeting, but I didn't have time to cover my...
2009-02-05
402 reads
I've been busy with other projects and haven't had time to focus as much as I'd like on my SQLSaturday...
2009-02-05
487 reads
If you're thinking about taking a job as a manager there are two questions that will help you quickly understand...
2009-02-04
945 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