Re: XML Outputs

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: vvenk (vvenk_at_discussions.microsoft.com)
Date: 11/02/04 

Date: Tue, 2 Nov 2004 09:59:01 -0800

Alex:

I am executing these SQL statements in Query Analyzer.

Can I not create XML documents interactively using Analyzer?

Venkat

"Alex Shirshov" wrote:

> Hello, vvenk!
> You wrote on Tue, 2 Nov 2004 05:41:02 -0800:
>
> v> How can I create fully valid XML documents in SQL Server 2000?
>
> If you are using ADO, you could specify the root by using "xml root"
> extended property of the ADODB.Command object.
> If you are using managed classes, see RootTag property of the SqlXmlCommand.
>
> With best regards, Alex Shirshov.
>
>
>

Relevant Pages

  • Re: ADODB.Connection funkiness
    ... multiple servers. ... submit and the all the SQL statements we've typed into the form are ... the semi colon the statement executes. ... GO is a batch delimiter in Query Analyzer, outside of that it has no ...
    (microsoft.public.data.ado)
  • Re: SQL Server needs help from MS Access (or something)
    ... like is that you must save a view prior to running any SQL statements, ... unlike the query analyzer, which allows you to run code, and then just ... environment, a central repository, and works great in multi-database ...
    (comp.databases.ms-sqlserver)
  • Statement Help
    ... I have two SQL Statements that work great using Access as the front-end, but do not work at all using Query Analyzer as my front end. ... In Access the following two statements return the proper results (both statements accomplish the same thing - They both use a different technique to find unmatched records between two tables): ...
    (microsoft.public.sqlserver.programming)