New Personal Site Launched !
Hey there folks. I finally was able to get my persona domain name from a squatter who has been holding...
2009-10-21
390 reads
Hey there folks. I finally was able to get my persona domain name from a squatter who has been holding...
2009-10-21
390 reads
My presentation and sample files from SQLSaturday in Orlando are now online for you to download. Check them out at...
2009-10-21
386 reads
When working with a dimensionally modeled data warehouse it is common for a large number of your queries to follow...
2009-09-16
5,791 reads
There are many different ways to manipulate dates when working with them in SSIS. Many great examples have been posted...
2009-09-10
1,154 reads
Have you ever wondered where to go to get good information that will help you in your day to day...
2009-09-09
453 reads
Hey there Gang !
Most of you probably know Jamie Thompson has move his blog over to SQLBlog.com. This is worth noting...
2009-09-09
418 reads
There are many different ways to manipulate dates when working with them in SSIS. Many great examples have been posted...
2009-09-08
3,599 reads
Have you ever received the following error when developing your ETL or working with data cleanup?
Msg 544, Level 16, State...
2009-09-08
585 reads
Have you ever lost your project file for a SQL Server Analysis Services database? There is a great option to...
2009-09-08
595 reads
Intellisense is one of my favorite features in SQL Server Management Studio and BIDS for 2008. A common frustration I...
2009-09-08
974 reads
By Vinay Thakur
Continuing from Day 4 where we learned Encoder, Decoder, and Attention Mechanism, today we...
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...
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