<product:product xmlns:product="http://www.myco.com/product" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.myco.com/product rl-product+CustomProductCatalog+product.xsd " xmlns:enc="http://schemas.xmlsoap.org/soap/encoding/" ID="productprod000191" repositoryId="prod000191">
	<product:product.heightMax xsi:nil="true"/>
	<product:product.gender collectionType="List" componentType="string">
		<product:string>Womens</product:string>
	</product:product.gender>
	<product:product.displayName xsi:type="string"><![CDATA[a shirt, logo]]></product:product.displayName>
	<product:product.id xsi:type="string"><![CDATA[prod000191]]></product:product.id>
	<product:product.color collectionType="List" componentType="string">
		<product:string>Red</product:string>
		<product:string> White</product:string>
	</product:product.color>
	<product:product.childSKUs collectionType="List" componentType="itemRef">
		<product:childSKUssku ID="sku84016" repositoryId="84016">
			<product:sku.displayName xsi:type="string"><![CDATA[small, green]]></product:sku.displayName>
			<product:sku.newSku xsi:type="boolean">true</product:sku.newSku>
			<product:sku.listPrice xsi:type="double">16.95</product:sku.listPrice>
			<product:sku.id xsi:type="string"><![CDATA[84016]]></product:sku.id>
		</product:childSKUssku>
		<product:childSKUssku ID="sku84020" repositoryId="84020">
			<product:sku.displayName xsi:type="string"><![CDATA[large, green]]></product:sku.displayName>
			<product:sku.newSku xsi:type="boolean">true</product:sku.newSku>
			<product:sku.listPrice xsi:type="double">16.95</product:sku.listPrice>
			<product:sku.id xsi:type="string"><![CDATA[84020]]></product:sku.id>
		</product:childSKUssku>
	</product:product.childSKUs>
	<product:product.form xsi:nil="true"/>
</product:product>

SELECT
	1 AS Tag,
	NULL AS Parent,
	'Jacob' AS 'Person!1!Name!element',
	'Hellow world' AS 'Person!1!greeting!CDATA',
	'http://beyondrelational.com/xml.aspx' 
		AS 'Person!1!xmlns:x'
FOR XML EXPLICIT

--=================================================================================================================================
-- XML Workshop Part V Namespaces: el uso de NAMESPACES permite desambiguar el nombre de los elementos
/*
	normalmente en SQL usamos alias para desambiguar, en programación usamos clase.procedimiento para diferenciar 2 llamadas
	iguales en diferentes clases. En XML usamos Namespaces
*/
--=================================================================================================================================
--vamos a crear un XML de ejemplo
/*
<configuration>
   <connection>
	 <provider>World Wide Internet Providers</provider>
	 <speed>512 KBPS</speed>
   </connection>
   <connection>
	 <provider>SQL Client Provider</provider>
	 <protocol>TCP/IP</protocol>
	 <Authentication>Windows</Authentication>
  </connection>
</configuration>

 una aplicación que intente leer el XML anterior fallará pues tenemos el nodo connection repetido, aunque uno se refiere a
 Internet y el otro a SQL 

 modifiquemos el XML para tener en cuenta los namespaces

<configuration
	 xmlns:net="urn:www.dotnetquest.com/internetconnection"
	 xmlns:db="urn:www.dotnetquest.com/databaseconnection">
   <net:connection>
	 <net:provider>World Wide Internet Providers</net:provider>
	 <net:speed>512 KBPS</net:speed>
   </net:connection>
   <db:connection>
	 <db:provider>SQL Client Provider</db:provider>
	<db:protocol>TCP/IP</db:protocol>
	<db:Authentication>Windows</db:Authentication>
  </db:connection>
</configuration>
*/

--Veamos como generar un XML con esta estructura, primero crearemos las tablas necesarias e introduzcamos datos
-- Create the table for Net Connection
-- be aware that if using AdventureWorks database it has already a NetConnection table, you can temporary rename it or change test table name
CREATE TABLE NetConnection (Provider VARCHAR(50),Speed VARCHAR(20))

-- Populate the Table
INSERT INTO NetConnection(Provider, Speed)
SELECT 'World Wide Internet Providers','512 KBPS'

-- Create table for DB Connection
CREATE TABLE DbConnection (Provider VARCHAR(50),Protocol VARCHAR(20),[Authentication] VARCHAR(20))

-- Populate the Table
INSERT INTO DbConnection (Provider,Protocol,[Authentication] )
SELECT	'SQL Client Provider','TCP/IP','Windows'

--ahora crearemos el XML, usando la sentencia TSQL: WITH XMLNAMESPACES
WITH XMLNAMESPACES 
(
    'urn:www.dotnetquest.com/internetconnection' AS net,
    'urn:www.dotnetquest.com/databaseconnection' AS db
)
SELECT net.Provider AS 'net:Connection/net:Provider',
	net.Speed AS 'net:Connection/net:Speed',
	db.Provider AS 'db:Connection/db:Provider',
	db.Protocol AS 'db:Connection/db:Protocol',
	db.[Authentication] AS 'db:Connection/db:Authentication'
	 FROM NetConnection net
CROSS JOIN DbConnection db
FOR XML PATH('Configuration')