Dette gratis onlineværktøj lader dig konvertere SQL til XML. Ingen grund til at downloade eller installere nogen software. Klik for at konvertere din fil nu.
Eksempel fra SQL til XML
Input data
CREATE TABLE peoples(
id INTEGER PRIMARY KEY,
name CHAR(20),
age CHAR(2)
);
INSERT INTO peoples VALUES (1, 'name 1', '22');
INSERT INTO peoples VALUES (2, 'name 2', '33');
INSERT INTO peoples VALUES (3, 'name 3', '44');
INSERT INTO peoples VALUES (4, 'name 4', '55');
SELECT * FROM peoples
Outputdata
<?xml version="1.0" encoding="UTF-8" ?>
<root>
<row-0>
<id>1</id>
<name>name 1</name>
<age>22</age>
</row-0>
<row-1>
<id>2</id>
<name>name 2</name>
<age>33</age>
</row-1>
<row-2>
<id>3</id>
<name>name 3</name>
<age>44</age>
</row-2>
<row-3>
<id>4</id>
<name>name 4</name>
<age>55</age>
</row-3>
</root>