Reminder - SQLSaturday #4 in Orlando June 7-8, 2008
Last call! We've got a 2 day event running this time. Saturday is the more traditional (it's only #4 after...
2008-06-02
237 reads
Last call! We've got a 2 day event running this time. Saturday is the more traditional (it's only #4 after...
2008-06-02
237 reads
If you're not familiar with the term it means to make something safe/secure by using a trick to hide the...
2008-06-01
212 reads
Ran across this article about burnout and thought it worth posting. Burnout is not fun to experience and heading it...
2008-05-29
1,427 reads
Brian Kelley posted Giving a Presentation about a week ago and is worth reading, in particular his suggestion about Toastmasters...
2008-05-28
1,464 reads
Received news today that one of my submitted sessions - Should You Move Into Management - was accepted for the summit. Good...
2008-05-27
1,346 reads
I get a lot of questions about virtualization and really have few answers. At a high level it's not hard...
2008-05-25
1,682 reads
I'll be doing a presentation for the Steel City SQL Group on June 17 and then on June 18th I'm doing...
2008-05-23
1,375 reads
I read Andrew Binstock occassionally in SD Times and in the most recent issue he posted a list of guidelines...
2008-05-21
1,702 reads
Ran across this strange occurence while doing some testing. To duplicate the results (the actual code was a little more...
2008-05-20
1,480 reads
I've been working on a rough outline for two new classes that will each be one day long. One on...
2008-05-18
488 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