Perks at Work - A Good Thing?
Free oil changes, extra week of vacation when you get married, etc, etc, all things mentioned in this article someone...
2008-02-25
1,417 reads
Free oil changes, extra week of vacation when you get married, etc, etc, all things mentioned in this article someone...
2008-02-25
1,417 reads
I posted earlier about the event being a great success with more than 200 attendees, in this post I want...
2008-02-24
1,477 reads
The Summit is being held in Seattle, WA, Nov 18-21, 2008. Call for speakers is open through March 28. It's...
2008-02-21
1,427 reads
I recently attended SQLSaturday#2 in Tampa and had the brief chance to chat with David Hayden about LINQ (I suspect I...
2008-02-21
1,811 reads
I've been meaning to post this, Joe's latest book Joe Celko's Thinking in Sets: Auxiliary, Temporal, and Virtual Tables in...
2008-02-20
1,528 reads
When we first set up shop for End To End Training we knew we wanted both a flip chart and...
2008-02-19
1,603 reads
My business partnerBrian Knight just finalized the venue for the next SQLSaturday. Number three will be held at the University...
2008-02-19
1,217 reads
I had to run all the cables for all the machines in our classroom recently and you know how messy...
2008-02-18
1,459 reads
Are you ready to move into management? The jump from tech worker to management is a large one and Andy Warren shares some of his experience in making the leap with you.
2008-02-18
2,792 reads
I wrote Management because we typically get it so wrong in our line of work. Nothing better than working for...
2008-02-18
651 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