Listing 1: FOR XML EXPLICIT Query to Retrieve Open Content SELECT 1 AS TAG, NULL AS Parent, ProductID AS [LineItem!1!id], ProductName AS [LineItem!1!ProductName!element], UnitPrice AS [LineItem!1!Price!element], Overflow AS [LineItem!1!!xmltext] FROM Products WHERE ProductID = 22 FOR XML EXPLICIT