Closing Down SQLGroups.com
We (Brian, Steve, and I) provided hosting for SQL chapters going way back…maybe 2002 or 2003, on behalf of PASS....
2009-07-27
533 reads
We (Brian, Steve, and I) provided hosting for SQL chapters going way back…maybe 2002 or 2003, on behalf of PASS....
2009-07-27
533 reads
Sometime in the next couple weeks will mark the beginning of the 30 day period where we accept nominations for the...
2009-07-26
1,000 reads
Steve Lane and team from Tallahassee are hosting their annual Code Camp on Sep 5, 2009, and have asked if...
2009-07-26
658 reads
Stuart Ainsworth is launching SQLSaturday #24 & #25, both in Gainesville, GA on October 9th and 10th respectively, and yes, one...
2009-07-24
639 reads
Found The Candy Bombers: The Untold Story of the Berlin Airlift and America's Finest Hour by Andrei Cherny ($20 @ Amazon) ...
2009-07-23
544 reads
Continuing with his videos on Foreign Keys, MVP Andy Warren shows us how to set constraints between two tables.
2009-07-23
5,037 reads
This month I’m featuring Glenn Berry, a Denver based MVP that writes Glenn Berry's SQL Server Performance blog. He blogs...
2009-07-22
725 reads
MSSQLTips & Idera are sponsoring a contest where the grand prize in an all expenses paid trip to the PASS Summit...
2009-07-21
708 reads
Understanding referential integrity is important for anyone working with databases. It can help you design better forming systems. Learn the basics of foreign keys in this SQL School video.
2009-07-21
8,613 reads
Time for another update on all things PASS. I’ve been struggling to find time for PASS activities and having to...
2009-07-21
600 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