Thursday, March 13th, 2008
The Extensible Markup Language (XML) is certainly one of the hottest technologies at the moment. While the concept of markup languages is not new, XML seems especially attractive to Java and Internet programmers. The Java API for XML Parsing (JAXP), having recently been defined through the Java Community Process, promises ...
Posted in Java, Xml | No Comments »
Tuesday, January 29th, 2008
Microsoft SQL Server allows to return the results of a query in XML format.
Let's create a simple table:
create table test
(
field_a varchar(20),
field_b varchar(20)
);
insert into test values('Microsoft','SQL Server');
insert into test values('Oracle','Oracle Database');
SQL to XML transformation is very simple to use. It's done by adding following clause at the end of a query:
FOR ...
Posted in Ms Sql Server, Sql, Xml | No Comments »