So I’m hosting T-SQL Tuesday this month and decided that since security is something everyone has to deal with it...
2015-02-19 (first published: 2015-02-10)
7,222 reads
This isn’t so much of a best practice, it comes more under the heading of being careful. Let’s say you...
2015-02-18
2,226 reads
T-SQL is not the best language in the world for formatting strings. It can be done, but typically you are...
2015-02-16 (first published: 2015-02-05)
6,283 reads
When I decided on security as my topic for February’s T-SQL Tuesday blog party my thought was that security was...
2015-02-12
922 reads
Back in December I had the thought that it would be fun to do an email interview with someone. As...
2015-02-06 (first published: 2015-01-28)
6,820 reads
Come on down! You’re the next contestant on T-SQL Tuesday! I’m your host Kenneth Fisher and this month I’d thought...
2015-02-03
928 reads
Every month SQL Judo (Russ Thomas) (b/t) challenges us to do his Monthly DBA Challenge. I’ve decided it would be...
2015-01-29 (first published: 2015-01-26)
6,302 reads
EXCEPT and INTERSECT are two uncommon commands. Not that they do anything odd but they aren’t exactly well known in...
2015-01-23 (first published: 2015-01-19)
8,576 reads
It amazes me how much easier certain tasks have gotten in SQL Server. I was watching the Nov 2014 SQL...
2015-01-22 (first published: 2015-01-15)
8,834 reads
Have you ever seen a constraint with a name like PK__TableNam__EA185FBF8FF1529D? It’s kind of funny looking right? I mean it...
2015-01-21
1,927 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