Presenting in West Palm Beach on March 22, 2011
I’m pleased to be joining the West Palm Beach .Net group on March 22 to do a presentation on SQL...
2011-03-04
890 reads
I’m pleased to be joining the West Palm Beach .Net group on March 22 to do a presentation on SQL...
2011-03-04
890 reads
Part of why I love IT is finding patterns and creating new ones. Patterns by themselves are interesting, but when...
2011-03-04
1,149 reads
By default Firefox doesn’t pass through NT credentials, not a big deal when you’re browsing Amazon by a big pain...
2011-03-01
936 reads
Recently I had the chance to do some tuning on a system that was built using Grails (formerly Groovy on...
2011-02-28
2,478 reads
Today we have a guest editorial from Andy Warren. There are changes in the Microsoft Certified Master of SQL Server program and many people are considering trying to earn this certification. Today Andy Warren asks if you want to go down that path.
2011-02-28
343 reads
This week we posted some pending changes to the PASS bylaws. We try to do a review at least once...
2011-02-25
1,566 reads
Wirefly is a website devoted to purchasing cell phones and plans. I found it when I was researching my Droid...
2011-02-22
852 reads
I attended the second meeting of MagicPASS (no web site yet) on Feb 16 at Stetson University in Celebration, FL....
2011-02-18
554 reads
PASS isn’t what it should be. I hear that a lot, and in many ways I agree with you. We’re...
2011-02-18
556 reads
One of the things I enjoy about work is seeing the various cultures that evolve. Some companies are rigid, some...
2011-02-18
1,369 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