Arihant Webtech Pvt Ltd

Arihant Webtech Pvt Ltd is India based Digital Marketing Agency founded with a mission to give services to its customers at one stop shop. We create relations for long term business approach, your satisfaction is our duty in order to give results that will make you to come again for any work of website designing, website development, Website Promotion – Organic & Inorganic SEO through Search Engine Optimization, Social Media Optimization, PPC (Google Adwords), Email marketing, SEO friendly Content Writing services and many more.

Twitter: @https://twitter.com/arihantwebtech
Website: https://www.arihantwebtech.com/
LinkedIn: https://www.linkedin.com/company/arihant-webtech

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

Arihant Webtech Pvt Ltd

Blogs

AI: Blog a Day – Day 4: Transformers – Encoder, Decoder, and Attention

Flyway Tips: Multiple Projects

What DevOps Look Like in Microsoft Fabric

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