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 HeyMo0sh
Microsoft Fabric (not to be confused with the more general term “fabric” in DevOps)...
By James Serra
I’m honored to be hosting T-SQL Tuesday — edition #192. For those who may...
By Vinay Thakur
Continuing from Day 2 , we learned introduction on Generative AI and Agentic AI,...
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