Amar Hospital

Amar Hospital is a premier Multi Speciality Hospital in Patiala, known for its commitment to providing world-class medical care. With a team of highly qualified and experienced medical professionals, Amar Hospital delivers exceptional healthcare services across a range of specialties, including cardiology, orthopedics, neurology, oncology, and pediatrics. The hospital is equipped with state-of-the-art facilities, advanced diagnostic tools, and cutting-edge technology, ensuring accurate diagnoses and effective treatments for complex health conditions.

Website: https://amarhospital.com/

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

Amar Hospital

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