dmconsultant

Michael Clark is a seasoned technical writer with a keen eye for detail and a deep understanding of financial software applications. With years of experience crafting clear and user-friendly content, he specializes in guiding users through the complexities of accounting software such as QuickBooks and Sage. His ability to translate technical jargon into accessible language has made him an invaluable resource for both novice and experienced users alike. Michael Clark is committed to helping businesses streamline their financial processes and empowering users with the knowledge to leverage their software to its full potential.

Website: https://dmconsultant.co/

All authors

It seems we can’t find what you’re looking for. Perhaps searching can help.

Read the latest Blogs

Visit the forum

Question of the Day

Fun with JSON I

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

dmconsultant

Blogs

What DevOps Look Like in Microsoft Fabric

T-SQL Tuesday #192: What career risks have you taken?

AI: Blog a Day – Day 3: LLM Models – Open Source vs Closed Source

Forums

Can an Azure App Service Managed Identity be used for SQL Login?

Azure Synapse database refresh

how to write this query?

Question of the Day

Fun with JSON I