The Curious Engineer

All blogs / Databases

Typed XML in SQL Server 2005

learn.microsoft.com/en-us/archive/blogs/denisruc

Denis Ruckebusch's blog on typed XML in SQL Server 2005.

DatabasesMicrosoft blogsMSDN archive

’05’10’15’20’25
Posts
37 from 13 Jun 2005 to 26 Oct 2007
Posting
archived, read-only
Kind
personal blog
Feed
https://learn.microsoft.com/en-us/archive/blogs/denisruc/feed.xml

2007 4

  1. Moving on
  2. Silent XQuery failures
  3. Stardust memories
  4. A new SQL CLR blog

2006 14

  1. xsi:nil magic (part 2/2)
  2. xsi:nil magic (part 1/2)
  3. About my article in SQL Server Standard Magazine
  4. The latest issue of SQL Server Standard magazine is all about XML.
  5. Complementing XSD with CHECK constraints
  6. xsi:type magic
  7. Explaining the reasons behind some of XML datatype's limitations
  8. If you leave me now…
  9. Inserting an XML instance into another even though SQL type ‘xml’ is not supported in XQuery.
  10. Restricting the contents of a typed XML column using triggers
  11. Importing the Microsoft Office 2003 schemas into the database
  12. Download SP1 today!
  13. Importing an existing XML schema into SQL Server 2005
  14. Fixing non deterministic schemas

2005 19

  1. Working on SP1
  2. The long road to SQL Server 2005 ends here.
  3. Branching
  4. DML operations on multiple nodes
  5. How to preserve whitespaces
  6. Validating without typing
  7. Document and content
  8. Back from TechReady
  9. Using the XPath provided in XML validation error messages
  10. Improved error messages
  11. Static typing and substitution groups
  12. Substitution groups and their effects on type derivation
  13. Effects of the type substitution mechanism on static typing (part II)
  14. New blog by a SQL Server 2005 tester.
  15. Effects of the type substitution mechanism on static typing (part I)
  16. For more info on XQuery singleton issues
  17. Single node required
  18. An introduction to static typing.
  19. Welcome