Returning Results from an Insert – OUTPUT clause
I needed to return an identity value recently from an insert for use in another piece of code. For a...
2012-02-02 (first published: 2012-01-30)
3,587 reads
Steve Jones
- Interests: yoga, reading, biking, snowboarding, volleyball
- Twitter: @way0utwest
- Website: https://www.voiceofthedba.com
- LinkedIn: https://www.linkedin.com/in/way0utwest
- Bluesky: way0utwest.bsky.social
- Threads: @way0utwest
2012-02-02
3,417 reads
A few quick time calculations
Have you ever needed to do a quick time calculations of the amount of hours/minutes/seconds that have passed? Suppose you...
2012-02-01
1,105 reads
Disk Drives in the Sky
Steve Jones talks today about storage innovations from the large cloud vendors and how that can relate to your job as a database professional.
2012-02-01
118 reads
Morale Data
Would any of you want to track your morale at work and have your boss access the data anonymously? Steve Jones think it's a good tool, but one that is easily abused.
2012-01-30
141 reads
2012-01-30
83 reads
2012-01-30
1,887 reads
Healthy Work Habits
Today Steve Jones talks a little about the work environment for IT workers. We ought to pay attention and ensure we are taking care of ourselves.
2012-01-26
234 reads
Enabling Compression? Update your baseline
I wrote recently about capacity planning, with an item near the end about disk usage. Someone pointed out to me...
2012-01-25
1,075 reads
No Cloud for Stack Exchange
The use of cloud computing isn't in the plans for the Stack Exchange network of sites? Steve Jones thinks they have a pretty cool reason not to use the cloud and he thinks you ought to have a similar view at work.
2012-01-25
75 reads
Blogs
In-Person CISA Training – April 13-16, 2026
By Brian Kelley
I will be leading an in-person Certified Information Systems Auditor (CISA) exam prep class...
EightKB 2026
EightKB is back again for 2026! The biggest online SQL Server internals conference is...
The FinOps Lifecycle: From Budgeting to Reporting
By HeyMo0sh
Working in DevOps long enough teaches you two universal truths: That’s exactly why I...
Forums
VS Code, Unresolved References.
Hi all, I just started using VS Code to work with DB projects. I...
Fun with JSON II
Comments posted to this topic are about the item Fun with JSON II
Changing Data Types
Comments posted to this topic are about the item Changing Data Types
Question of the Day
Fun with JSON II
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 t1.[key] AS row,
t2.*
FROM OPENJSON(
(
SELECT t.* FROM #test_data AS t FOR JSON PATH
)
) t1
CROSS APPLY OPENJSON(t1.value) t2; See possible answers