Lunch Story #3–No Free Sandwiches
This time the plan was to go to Arby’s because it was close and my friend Rob had coupons for...
2010-12-23
557 reads
This time the plan was to go to Arby’s because it was close and my friend Rob had coupons for...
2010-12-23
557 reads
We’ve updated the original flyer to the new and improved model that has the prices. The image below is a...
2010-12-23
717 reads
I read a lot, and often marvel at the effort that goes into writing them, and I think I get...
2010-12-22
615 reads
Lately I’ve been having some unusual lunches, starting with the bbq fiasco from last week. For this one I have...
2010-12-20
583 reads
Sent by a friend (yes, it’s a mild fake), but still, shouldn’t someone open a SQL bar or coffee place?
2010-12-17
582 reads
This Friday we have a guest editorial from Andy Warren that asks about those features in SQL Serve that you find very useful, but perhaps aren't as well known.
2010-12-17
595 reads
Recently some friends invited me to try a BBQ place that they enjoyed, so I went along hoping for the...
2010-12-17
594 reads
Our December meeting was a time for a lot of changes:
New location, the Hampton Inn in Lake Mary. It’s further...
2010-12-16
589 reads
Email consumes a pretty significant chunk for me. Email for my day job, email for my blog, email from friend...
2010-12-15
873 reads
Over my career I’ve seen interviews fall into three categories:
The technical part. Questions on trace flags, wait states, backups, etc,...
2010-12-14
612 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