Search Results

  1. Demystify SQL Server FOR XML EXPLICIT By Robbe Morris

    FOR XML EXPLICIT is an option in SQL Server 2000 that allows you to return your results in a structure specifically defined by you. It is much more powerful ...
    www.eggheadcafe.com/articles/20030804.asp - Cached - Similar

  2. FOR XML EXPLICIT Tutorial – Part 4 - Jacob's Blog

    Jan 7, 2009 ... Continued from FOR XML EXPLICIT Tutorial – Part 3 This is a late addition to the 3 part FOR XML TUTORIAL I wrote last year.
    beyondrelational.com/.../for-xml-explicit-tutorial-part-4.aspx - Cached - Similar

  3. Using EXPLICIT Mode

    The EXPLICIT mode query must be written in a specific way so that the additional information about the required XML, such as expected nesting in the XML, ...
    msdn.microsoft.com/en-us/library/ms189068.aspx - Cached - Similar

  4. What's New in FOR XML in Microsoft SQL Server 2005

    Unfortunately, FOR XML results in SQL Server 2000 can only be consumed on the client side, and authoring complex XML structures using FOR XML EXPLICIT is a ...
    msdn.microsoft.com/en-us/library/ms345137(SQL.90).aspx - Cached - Similar

  5. How can I get my FOR XML EXPLICIT query to work?

    Jun 30, 2002 ... What FOR XML EXPLICIT does is it takes that table format and create the XML .... After executing the SQL using XML EXPLICIT, how do I get the resultant XML ...
    sqlxml.org/faqs.aspx?faq=28 - Cached - Similar
    How To: Shape FOR XML AUTO results using SQL views‎ - Nov 4, 2003
    How To: Combine FOR XML AUTO queries using XSL‎ - Oct 22, 2003
    How can I use aggregates and the group by clause with FOR XML?‎ - Mar 14, 2003
    How do I get a root element with my FOR XML query?‎ - Jun 30, 2002

    More results from sqlxml.org »

  6. seperate article - Windows and Linux Web Hosting, Free Web Hosting ...

    This article explores the various usage of XML EXPLICIT and the meaning of the above syntax. Before we get into the nuances of this command, let's take an ...
    www32.brinkster.com/srisamp/sqlArticles/article_21.htm - Cached - Similar

  7. iAnywhere.com - Using FOR XML EXPLICIT

    FOR XML EXPLICIT allows you to control the structure of the XML document returned by the query. The query must be written in a particular way so that ...
    www.ianywhere.com/developer/product.../00000534.htm - Cached - Similar

  8. InformIT: The EXPLICIT Mode of FOR XML > The EXPLICIT Mode of FOR XML

    Mar 8, 2010 ... You don't need to be a rocket scientist, but the FOR XML EXPLICIT clause takes a little while to get used to. This article by Baya ...
    www.informit.com › Articles - Cached - Similar

  9. FOR XML EXPLICIT - Stack Overflow

    Hi,. Say I have this setup: -- tables declare @main table (id int, .... tables declare @main table (id int, name varchar(20)) declare @subA table (id int, ...
    stackoverflow.com/questions/1887344/for-xml-explicit - Cached

  10. Retrieving Data as XML from SQL Server

    "for xml explicit": Explicit mode is the most complex shaping method used in SQL Server 2000. It allows users to query a data source in such a way that the ...
    articles.sitepoint.com › ... › XML, XSLT & Web Services - Cached - Similar