More LINQ Discussion
Steve Jones recently posted an editorial about LINQ and the resulting discussion encapsulates most of the points of view on...
2008-04-24
1,771 reads
Steve Jones recently posted an editorial about LINQ and the resulting discussion encapsulates most of the points of view on...
2008-04-24
1,771 reads
Ran across this in the Mar/Apr ACM Queue, http://www.eecs.berkeley.edu/IPRO/JimGrayTribute/ will be held at UC Berkeley on May 31st, 2008. Jim Gray...
2008-04-24
1,358 reads
Most of that do any time of training or consulting typically use laptops, and they are even reasonably common in...
2008-04-23
1,614 reads
Ran across this from Mosso, a spin off from Rackspace. Pricing looks very attractive, and there are some interesting twists....
2008-04-22
1,708 reads
As you may know MS Teched is two weeks this year and is being held in Orlando. Turns out that...
2008-04-22
1,328 reads
Our Dell rep sent over this link about Equilogic ISCSI SAN's, pricing is not yet posted but according to him,...
2008-04-21
866 reads
Someone asked me this recently and I really had no idea. Quick look in BOL didn't yield any results, so...
2008-04-21
1,819 reads
Someone asked me for these recently as they predate the blog. All were posted on SSC over the past couple...
2008-04-17
623 reads
As a mentor I'm looking for someone with the drive to learn and grow, and willing to acknowledge that they...
2008-04-17
534 reads
One of the dangers of mentoring someone on your team is that you can easily be perceived as biased, and...
2008-04-16
464 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