FOR XML code that appears above query results - XML SOAP

Hello Internet,

> When I query using FOR XML, query ****yzer always returns some kind of
> ID code prior to the query results, e.g.:

What you are using is the name the query engine gave the column of output.
For example:

using System;
using System.Data;
using System.Data.SqlClient;
namespace forxml {
class Program {
static void Main(string[] args) {
using (SqlConnection conn = new SqlConnection("Data Source=.;Initial
Catalog=northwind;Integrated Security=True")) {
conn.Open();
using (SqlCommand cmd = conn.CreateCommand()) {
cmd.CommandText = "select top 1 * from dbo.employees
for xml auto,elements,xmlschema";
cmd.CommandType = CommandType.Text;
using (SqlDataAdapter da = new SqlDataAdapter(cmd)) {
DataTable dt = new DataTable("this");
da.Fill(dt);
foreach (DataColumn c in dt.Columns) {
Console.WriteLine(c.ColumnName);
}
}
}
}
Console.ReadLine();
}
}
}

What it isn't imporantant, its more or less meaningless. If it bothers you,
consider using this form of the query instead...

;with results(col) as (select top 1 * from dbo.employees for xml auto,elements,xmlschema,type)
select col from results

Then you can call it what you like.

Thanks,
Kent Tegels, DevelopMentor
http://staff.develop.com/ktegels/