Dialects in SQL Server 2K


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2

Thread: Dialects in SQL Server 2K

  1. #1
    John Guest

    Dialects in SQL Server 2K


    Hi, Rob:

    Iím pretty confused on the subject of the Dialect property, used when retrieving
    XML data from SQL Server 2000 into a Stream object. What exactly does the
    Dialect property do? Does it hurt my performance to use the default dialect
    {C8B521FB-5CF3-11CE-ADE5-00AA0044773D}? A number of the MSDN examples us
    a different dialect {5D531CB2-E6Ed-11D2-B252-00C04F681B71}, but when I used
    it on my server (which has MSXML3 installed), I received an error message
    for malformed XML that referenced MSXML2. Is there a different GUID I should
    use for MSXML3? What does all of this mean?

    Thanks!

    -- John

    Share on Google+

  2. #2
    Rob Vieira Guest

    Re: Dialects in SQL Server 2K

    The GUID that you use with the Stream object defines what the language is
    that you're using in your command stream. The Stream object currently has
    dialects that let you put XML templates (just like those you can also store
    in a file) on the stream. In addition, there are dialects for using straight
    T-SQL and for XPath.

    I may do a white paper on this on my website at a later date, but, for now,
    check out the follow article on MSDN:

    http://msdn.microsoft.com/library/ps...prg03_2u2c.htm

    --
    Rob Vieira MCSD, MCT, MCDBA
    www.ProfessionalSQL.com


    "John" <JohnDWest@attglobal.net> wrote in message
    news:3a6d1cad$1@news.devx.com...
    >
    > Hi, Rob:
    >
    > I'm pretty confused on the subject of the Dialect property, used when

    retrieving
    > XML data from SQL Server 2000 into a Stream object. What exactly does the
    > Dialect property do? Does it hurt my performance to use the default

    dialect
    > {C8B521FB-5CF3-11CE-ADE5-00AA0044773D}? A number of the MSDN examples us
    > a different dialect {5D531CB2-E6Ed-11D2-B252-00C04F681B71}, but when I

    used
    > it on my server (which has MSXML3 installed), I received an error message
    > for malformed XML that referenced MSXML2. Is there a different GUID I

    should
    > use for MSXML3? What does all of this mean?
    >
    > Thanks!
    >
    > -- John
    >



    Share on Google+

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center