When loading tables in Microsoft’s Parallel Data Warehouse (PDW) via T-SQL, one will soon encounter the need to load data into a new table. Whether the developer needs to...
2012-10-15
34 reads
This month has been wild. I’ve been out of town quite a bit for work, and started the month with...
2012-10-15
813 reads
Reblogged from Basit's SQL Server Tips:
SQL Server 2012 allows you to store file/directories in a special table called FileTable that...
2012-10-15
1,035 reads
Had a great Friday in Lafayette, LA on the campus of the University of Louisiana-Lafayette. 31 different teams submitted database...
2012-10-14
976 reads
Problem Statement
SQL Server has got in-built functions to convert the given string into LOWER() or UPPER() format but it does...
2012-10-14
1,311 reads
I received an email from my boss on the morning supervisors approve timesheets. He stated that they are complaining about...
2012-10-14
2,065 reads
Chennai SQL Serve User Group Meet for Oct'2012 happend today at Microsoft Traning Centre located in Radhakrishnan Road, Chennai.
Its pleasure seeing enthusiastic...
2012-10-13
903 reads
The San Francisco SQL Server User Group – Oct 10 2012 Thanks you everyone for attending session, here is the presentation...
2012-10-13
996 reads
2012-10-13
7 reads
2012-10-13
6 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