MSSQL Tutorial XML 18 codes

1 Create index on XML column

2 Creating xml Data Type Columns and insert data

3 FOR XML AUTO

4 FOR XML Syntax

5 Insert XML data to a XML type column

6 Insert XML data to database

7 Load XML data from a file to table

8 Modifying XML Data

9 Retrieve XML data using XPath

10 SELECT @ProductBillingXML query(ProductBillingOrderItemsItem)

11 Select for FOR XML AUTO

12 The FOR XML Clause

13 Using XML Indexes

14 Using XML with Open Schema

15 XML query on XML column

16 XML type column

17 XPath query on XML

18 XPath search and element index