Title: SQL Server-XML-Lesson 1-Using ‘for xml’, ‘auto’, and ‘raw’ to generate xml from table data
Duration: 16 minutes
Summary: This is our first video of using XML in SQL Server. Support for XML started since SQL Server 2000. Since then many new enhancements has been added specially in SQL Server 2005. [You can download SQL Server Express for free from the internet; You can also download the AdventureWorks database]. In this video, I will show you how you can select data from tables as XML. To do this, we use ‘for xml’ option. ‘for xml’ also supports ‘auto’, ‘raw’, and ‘elements’ to provide different ways of retrieving xml data (for example, elements versus attributes).
Methodology of the development of example: Good coding standard and simplified design to illustrate the key points.
Technology Used: XML and SQL Server 2008
Keywords: XML, select, from, database, varchar, for, auto, elements, top, raw, root, xsinil.