2008-01-02
2,903 reads
XML
XML Workshop XIII - XSD And Variable Content Containers
Continuing on with his highly popular XML series, Jacob Sebastian looks at variable content and stylesheets in your SQL content.
2007-12-19
3,873 reads
Serve SQL Data in XML Format
Ivan Pepelnjak describes a few ways to extract data from SQL databases and serve it to an AJAX application running in a web browser.
2007-12-19
2,780 reads
XML Workshop XII - Parsing a delimited string
Continuing with his series on XML structures, this article looks at how to split a string up using XQUERY.
2007-12-05
7,197 reads
Storing XML Data in a Relational Database
Use familiar XML markup to extend the capabilities of your relational database.
2007-12-05
2,565 reads
XML Workshop XI - Default Namespaces
The eleventh installment of the XML Workshop continues looking at namespaces. This time Jacob Sebastian examines default namespaces and how they impact your XML processing.
2007-11-21
4,526 reads
XML Workshop X - Working with namespaces
With the tenth installment of his series on XML, Jacob Sebastian turns his attention to the art of namespaces and how you can avoid ambiguity in interpreting various elements.
2007-11-07
5,809 reads
XML Workshop IX - Mixed Types
Continuing on with his great series on XML, Jacob Sebastian looks at elements of mixed types.
2007-10-31
3,647 reads
XML Workshop VIII - Custom Types and Inheritance
This is the 8th installment of my XML Workshop which aims at explaining the details of working with XML in TSQL.
2007-10-17
3,707 reads
XML Workshop VII - Validating values with SCHEMA
This installment of the XML Workshop by Jacob Sebastian continues looking at XML Schemas in SQL Server 2005. Here we learn how the format and range of values can be checked using an XML schema.
2007-09-19
4,988 reads
Blogs
AI: Blog a Day – Day 4: Transformers – Encoder, Decoder, and Attention
By Vinay Thakur
Continuing from Day 3 where we covered LLM models open/closed and their parameters, Today...
Flyway Tips: Multiple Projects
By Steve Jones
One of the nice things about Flyway Desktop is that it helps you manage...
What DevOps Look Like in Microsoft Fabric
By HeyMo0sh
Microsoft Fabric (not to be confused with the more general term “fabric” in DevOps)...
Forums
Can an Azure App Service Managed Identity be used for SQL Login?
I'm fairly certain I know the answer to this from digging into it yesterday,...
Azure Synapse database refresh
Hi Team, I am trying to refresh the Azure Synapse Dedicated pool from production...
how to write this query?
hi everyone I am not sure how to write the query that will produce...
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