White Paper Wednesday – Data-tier Applications in SQL Server 2008 R2
Hey folks,
It’s white paper Wednesday again and this week Data-tier Applications in SQL Server 2008 R2 by Alan Brewer, Roger...
2010-08-12
399 reads
Hey folks,
It’s white paper Wednesday again and this week Data-tier Applications in SQL Server 2008 R2 by Alan Brewer, Roger...
2010-08-12
399 reads
Hey folks,
It’s white paper Wednesday and this week we’re looking at High Availability with SQL Server 2008 by Paul...
2010-08-11
218 reads
Hey folks - Dont 'forget to check out SQL Lunch today. I'm hosting Mr. Andy Leonard! Always exciting and cool information.....
2010-08-09
396 reads
With everyone geared up for SQL Cruise I’m surprised we can air this video but since we kicked it off...
2010-08-07
203 reads
Ok folks, the video from SQL Saturday 40 is finally up. Thanks to the sponsors who helped foot the bill...
2010-08-07
276 reads
This post is the first in a new weekly series meant to give my readers some insight into my week....
2010-08-07
344 reads
In life, many times we get confused by symbols or indicators that we make assumptions about. You know what they...
2010-08-04
183 reads
Today's motivation is that you had nothing to do with this. IF this Pilot had the equivalent of a community...
2010-08-04
184 reads
Goor Morning folks !
It's time for another motivational Monday. Today I want to remind you to be careful about biting...
2010-08-04
487 reads
This week it's all about speed. Many thing in life are drive n by how fast we can get them...
2010-08-04
199 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