Welcome to MSDN Blogs Sign in | Join | Help

May 2006 - Posts

Wednesday, May 17, 2006 12:55 PM

Inserting an XML instance into another even though SQL type ‘xml’ is not supported in XQuery.

Since we shipped SQL Server 2005 I have seen a few users ask if there was a simple way to insert an XML instance into another one. For simplicity’s sake, in the rest of this post I’m going to assume that all my variables contain valid XML documents (a
Posted by denisruc | 25 Comments
Filed under:
Friday, May 12, 2006 4:26 PM

Restricting the contents of a typed XML column using triggers

A typed XML column/variable is constrained by a schema collection. That means only instances that can be validated against the schemas in the collection will be accepted. You can tighten the rules a little bit with the use of the DOCUMENT facet, which
Posted by denisruc | 0 Comments
Filed under: ,
Tuesday, May 02, 2006 2:35 PM

Importing the Microsoft Office 2003 schemas into the database

As promised earlier I'm going to give you an example using a real-world schema. I've chosen to work with the Office 2003 schemas but I'm going to limit myself to Word and Excel. First, you need to install the schemas from here . In the T-SQL samples below
Posted by denisruc | 1 Comments
Filed under: ,
 
Page view tracker