A SIMPLE XML EXTRACT USING SQL SERVER 2000
"SELECT...FOR XML RAW"
|
A SIMPLE XML EXTRACT USING SQL SERVER 2000 "SELECT...FOR XML RAW" |
The SQL connection string is ="SELECT * from glmaster FOR XML RAW"
Note: The connection is OLEDB NOT DSN.
MS SQL Server 2000 returns 1 tag per table row (cleverly named row) with each column value as an attribute.
The XML is returned to the client as an XML data island and rolled out through javascript using the XML DOM.
Click "VIEW", then "SOURCE" to see the XML data island and the javascript XMLDOM rollout
Execution begins...
This tag name not cannot be modified.