Speaker Gift for SQLSaturday #49
We’ve tried to move away from shirts as a speaker gift, most speakers have them so we only get them...
2010-10-12
505 reads
We’ve tried to move away from shirts as a speaker gift, most speakers have them so we only get them...
2010-10-12
505 reads
I had a question recently about how budgets work at PASS, and I think that’s something worth sharing, so I’m...
2010-10-11
518 reads
Great title for a post, isn’t it? Seems foolish, lazy, or worse to plan for failure, right? Yet, in the...
2010-10-08
313 reads
I found The Literacy Project at Google after seeing a local op-ed piece about literacy. I love to read, a...
2010-10-07
441 reads
Not often I do plugs here, but then again, it’s rare that I just get first class service, so read...
2010-10-07
384 reads
If you haven’t used it (and I rarely do myself), Ident_Current (‘tablename’) returns the last identity value generated across all...
2010-10-06
958 reads
See my previous post on the topic,or just go directly to the application.The application has full details, but MVP’s, Summit...
2010-10-05
357 reads
I wrote the editorial about great service after noticing a couple small but interesting customer service experiences during two trips....
2010-10-05
430 reads
Back in 2007 when we started SQLSaturday we had the good luck to leverage an existing relationship between Seminole Community...
2010-10-04
752 reads
I drove up on Friday, just under 7 hours with a couple quick stops on the trip. Listened to Team...
2010-10-04
508 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