Seminar on XML Data and XQUERY in SQL Server
SQL Server provides a powerful platform for developing rich applications for semi-structured data management. Support of XML is integrated into all the components of SQL SERVER which includes XML data type, ability to specify XQuery on XML data, managing bulk loading of XML data, retrieving relational data in XML format(FOR XML), retrieving XML data in relational format(OPENXML) etc. This session will be beneficial for people with basic knowledge of SQL SERVER.
The agenda for the session would include -
Basic Syntax and use of XML data type
Basic Syntax of the FOR XML Clause
Use RAW Mode with FOR XML
Use AUTO Mode with FOR XML
Use EXPLICIT Mode with FOR XMLs
Use PATH Mode with FOR XML
OPENXML
XQuery on XML data
Presenter: Bishwaranjan Sandhu, ASP.NET Developer, Mindfire Solutions