Guest_imported
New member
- Jan 1, 1970
- 0
I don't understand, why I input the following SQL statement have an incompleted result(XML)?
Some records are missing(My database don't have NULL value)
* element loginame and accright data missing!!!
Thank you for give me some tips.
SQL Statement:
Select 1 as Tag, 0 as Parent,
accessctrl.accno as [accessctrl!1!accno!xml],
accessctrl.loginame as [accessctrl!1!loginame!xml],
accessctrl.passwd as [accessctrl!1!passwd!xml],
accessctrl.accright as [accessctrl!1!accright!xml]
from accessctrl FOR XML EXPLICIT, XMLDATA;
Result:
<Schema name="Schema1" xmlns="urn:schemas-microsoft-com:xml-data" xmlns:dt="urn:schemas-microsoft-com:datatypes">
<ElementType name="accessctrl" content="mixed" model="open">
<element type="accno" />
<element type="loginame" />
<element type="passwd" />
<element type="accright" />
</ElementType>
<ElementType name="accno" content="mixed" model="closed" dt:type="i4" />
<ElementType name="loginame" content="mixed" model="closed" dt:type="string" />
<ElementType name="passwd" content="mixed" model="closed" dt:type="string" />
<ElementType name="accright" content="mixed" model="closed" dt:type="i4" />
</Schema>
<accno>1</accno>
<passwd>victor</passwd>
<accno>2</accno>
<passwd>tony</passwd>
<accno>3</accno>
<passwd>cat</passwd>
Some records are missing(My database don't have NULL value)
* element loginame and accright data missing!!!
Thank you for give me some tips.
SQL Statement:
Select 1 as Tag, 0 as Parent,
accessctrl.accno as [accessctrl!1!accno!xml],
accessctrl.loginame as [accessctrl!1!loginame!xml],
accessctrl.passwd as [accessctrl!1!passwd!xml],
accessctrl.accright as [accessctrl!1!accright!xml]
from accessctrl FOR XML EXPLICIT, XMLDATA;
Result:
<Schema name="Schema1" xmlns="urn:schemas-microsoft-com:xml-data" xmlns:dt="urn:schemas-microsoft-com:datatypes">
<ElementType name="accessctrl" content="mixed" model="open">
<element type="accno" />
<element type="loginame" />
<element type="passwd" />
<element type="accright" />
</ElementType>
<ElementType name="accno" content="mixed" model="closed" dt:type="i4" />
<ElementType name="loginame" content="mixed" model="closed" dt:type="string" />
<ElementType name="passwd" content="mixed" model="closed" dt:type="string" />
<ElementType name="accright" content="mixed" model="closed" dt:type="i4" />
</Schema>
<accno>1</accno>
<passwd>victor</passwd>
<accno>2</accno>
<passwd>tony</passwd>
<accno>3</accno>
<passwd>cat</passwd>