XML Schema validation in SQL Server
An introduction to the XML Schema Collection and XML validation.
2014-04-17
13,503 reads
XSD
Script SQL Table Schema as XML-XSD
When creating XML messages for Service Broker or other applications use this simple method to build a validation XSD.
2009-10-28 (first published: 2009-10-06)
1,370 reads
A Generic Process to Convert XML Data - Part 2
Continuing with his series on loading and transforming XML data, Leo Peysakhovich shows how to create the generic process to perform the convesions.
2009-07-10 (first published: 2008-08-26)
12,761 reads
A Generic Process to Convert XML Data - Part 1
Longtime author Leo Peysakhovich brings us a new series on converting XML data into regular data. This article examines validating the XML data against a schema.
2009-07-03 (first published: 2008-08-25)
16,505 reads
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,674 reads
2004-03-30
Conditional OUTER JOIN
Is there a way to do the following without using a UDF?Goal: To return all client records with their primary email if they have one, NULL if not.All client records can have to 0 to many email records, only one of which will have the IsPrimaryEmail bit set.Returning columns from two tables Clients and EmailPseudo […]
2004-03-24
3 reads
RE: Software to Compress Large File
I am using SQL LITE SPEED. FOR my sql backups. And it works great. Decreased file backup from 10 gigs to 1 gig. Great Utility. Has anyone used it before.
2003-06-27
2 reads
2003-05-29
1 reads
RE: Find out Access Table Names via DTS
Ok, I tried the script a couple of different ways using QA and Profiler. When I tried just running the script exactly as you had it, it failed during the insert into #Tables, about half way through it, no surprise there. When I changed @Filename to a valid file on my system using the UNC, […]
2003-05-29
1 reads
Blogs
Small Data SF 2024
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
A New Word: Moledro
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Snowflake + Azure blob
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers