By Steve Bolton
…………The pinnacle of difficulty in this series of amateur self-tutorials on SQL Server Data Mining (SSDM) was surmounted...
2013-10-23 (first published: 2013-10-15)
2,111 reads
By Steve Bolton
…………Throughout this series of amateur self-tutorials in SQL Server Data Mining (SSDM), I’ve often said that working with...
2013-09-16
1,436 reads
By Steve Bolton
…………As I’ve said many times throughout this series of amateur mistutorials, SQL Server Data Mining (SSDM) is one...
2013-09-02 (first published: 2013-08-26)
2,765 reads
by Steve Bolton
…………As expected, I’ve run into quite a few obstacles while trying to deploy and debug my first plug-in...
2013-07-31
1,079 reads
by Steve Bolton
…………In my last post in this amateur series of self-tutorials on SQL Server Data Mining (SSDM), I got...
2013-06-27 (first published: 2013-06-25)
2,722 reads
by Steve Bolton
I was drawn into the realm of SQL Server in a roundabout manner thanks to Visual Basic. Around...
2013-05-30 (first published: 2013-05-23)
4,176 reads
by Steve Bolton
It may set a SQLServerCentral record for the thickest alphabet soup of acronyms ever crammed into a...
2013-05-09
2,592 reads
by Steve Bolton
Anyone who’s gotten this far in this series of amateur self-tutorials on SQL Server Data Mining (SSDM)...
2013-05-02 (first published: 2013-04-16)
3,004 reads
by Steve Bolton
Throughout this series of amateur self-tutorials on SQL Server Data Mining (SSDM) I’ve typically included some kind...
2013-04-26
2,661 reads
by Steve Bolton
In the last two installments of this series of amateur self-tutorials on SQL Server Data Mining (SSDM),...
2013-04-10 (first published: 2013-04-01)
3,783 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