TDDD43 Advanced Data Models and Databases
Resources for theme 3
- Data sets
MSDN: Implementing XML in SQL Server
Information on how to use the XML data type in MS SQL Server. The most useful for the laboration in theme 3 are probably:
Creating XML Data Type Variables and Columns
How to create a column with the XML data type (HShreX already does this, check resulting table definitions created by Shrex.)
xml Data Type Methods
Methods you need for queries on XML data in MS SQL server, e.g. using .query() for XQuery resulting in XML.
Generating XML Instances
How to populate XML columns with data, either as specified by you in the console or read from file (see link to bulk importing for the latter).
- Creating XML Data Type Variables and Columns
Page responsible: Patrick Lambrix
Last updated: 2011-09-20