One Long Week
It started on Saturday. I usually have lunch with one or both of my daughters on the weekend and this...
2019-01-21
209 reads
It started on Saturday. I usually have lunch with one or both of my daughters on the weekend and this...
2019-01-21
209 reads
Most of the work I’ve done for the past couple years doesn’t require taking much in the way of notes....
2018-12-28 (first published: 2018-12-04)
2,691 reads
Just received an email from Meetup with some news on enhancements and one of them was interesting to me – the...
2018-12-26
245 reads
Yesterday I posted about journaling with my goal being to track the time I spend on SQLOrlando (I’ll exclude time...
2018-12-24 (first published: 2018-12-05)
1,634 reads
Orlando Code Camp is March 30. 2019 in Lake Mary (same location as SQLSaturday Orlando) and we’re hoping to have...
2018-12-22
247 reads
We use Meetup for SQLOrlando. We have enough members that we have to pay for the service and it works...
2018-12-18
245 reads
Part of having 501c(3) status is figuring out where and how it might make a difference. Applying for non profit...
2018-12-11
240 reads
Part of the decision of setting up a non profit is committing to a bit more than minimal effort when...
2018-12-07 (first published: 2018-11-26)
1,724 reads
I’ve always been in favor of trying to use the PASS tools and web site as much as possible, but...
2018-12-07
756 reads
Notes:
19 attendees out of 44 registeredSQLGrease sponsoredSolid hour of networking before the meeting started, managed to get everyone talking to...
2018-12-06
290 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