Minimalist Design
I'm been in tactical mode lately, building an advertising management system for one of our projects. Actually it's v2, the...
2009-03-25
1,608 reads
I'm been in tactical mode lately, building an advertising management system for one of our projects. Actually it's v2, the...
2009-03-25
1,608 reads
Yesterday I was commenting on how a big part of stress for me is getting that sudden burst of work...
2009-03-24
819 reads
Registration has been open since the last Summit, but this year Bill Graziano and team have released the Summit 2009...
2009-03-24
587 reads
In this SQL School video, learn how the UNION statement can help you join together results from different queries. MVP Andy Warren explains this T-SQL statement.
2009-03-24
6,822 reads
The call for speakers is open through midnight on April 10, 2009, so get busy submitting those abstracts! Work hard on the title and description, make it something that seems interesting and compelling for attendees. Expect the competition to be fierce...The call for speakers is open through midnight on April 10, 2009, so get busy submitting those abstracts! Work hard on the title and description, make it something that seems interesting and compelling for attendees. Expect the competition to be fierce...
2009-03-24
950 reads
As I gain more experience I've found that stress comes in three forms; stress that is there that you don't...
2009-03-23
582 reads
The call for speakers is open through midnight on April 10, 2009, so get busy submitting those abstracts! Work hard...
2009-03-22
745 reads
I was browsing the March 2009 issue of Visual Studio Magazine today and found that it's changing again. It's been...
2009-03-19
777 reads
This SQL School video shows how you can speed up your backup process by striping the backup across multiple disks. MVP Andy Warren narrates.
2009-03-19
3,623 reads
I've been slowly looking at and experimenting with LinkedIn to see if it has value and if so, how to...
2009-03-19
905 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