Results of PASS Summit 2010 Content Survey Released
A few weeks back PASS sent out a survey to get input on how to shape the 2010 Summit agenda,...
2010-04-22
535 reads
A few weeks back PASS sent out a survey to get input on how to shape the 2010 Summit agenda,...
2010-04-22
535 reads
Most of us have some general rules we live by, and I’ve often thought it would be a lot easier...
2010-04-21
725 reads
We just put the site up, starting a little earlier than last year, and over the course of this week...
2010-04-21
497 reads
Found Ninite while browsing a list of efficiency tools on PCWorld.com. It’s a one stop super installer, you run through...
2010-04-20
626 reads
I’ve had this on my list to write about for a while, just didn’t have a great example until this...
2010-04-19
498 reads
I hear that registration is over 350 so far, with seats still available – but register soon! I’m driving up with...
2010-04-19
507 reads
First, some background. If you’ve been to the Summit you know that we have an opening night reception, lots of...
2010-04-16
1,118 reads
A few weeks back I was in Chicago for three days for work. I’ve been through the airport a couple...
2010-04-16
952 reads
I’ve been waiting on this for a while, and missed the announcement that it was available, happened to see that...
2010-04-15
543 reads
SQLSaturday #38 is coming up on May 8th, 2010, back at the same location as in previous years at the...
2010-04-15
490 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