Is my SQL Server Pre-Release?
I get to work with a lot of different clients and client environments and like many companies they are often...
2010-08-19
344 reads
I get to work with a lot of different clients and client environments and like many companies they are often...
2010-08-19
344 reads
With everyone geared up for SQL Cruise I’m surprised we can air this video but since we kicked it off...
2010-08-19
354 reads
This week it's all about speed. Many thing in life are drive n by how fast we can get them...
2010-08-19
364 reads
Check out our latest book on Amazon. It’s not for sales yet, but just seeing the title up there is...
2010-08-19
352 reads
Ok folks, the video from SQL Saturday 40 is finally up. Thanks to the sponsors who helped foot the bill...
2010-08-19
325 reads
Well SQL Saturday here in South Florida was QUITE an event this past weekend. We had over 400+ attendees and...
2010-08-19
472 reads
One of the most common questions I get from folks during out quickstart engagements is around a new service in...
2010-08-19
469 reads
This is long overdue and goes out to my buddies from the SSAS Class I taught late last year. Two...
2010-08-19
386 reads
Some great SQL Lunch sessions are coming up. Some from Pragmatic folks and some from other great speakers and community...
2010-08-19
368 reads
Some great SQL Lunch sessions are coming up. Some from Pragmatic folks and some from other great speakers and community...
2010-08-19
387 reads
By Vinay Thakur
Continuing from Day 4 where we learned Encoder, Decoder, and Attention Mechanism, today we...
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...
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