Post reply

Is XML Useful for Array Data?

  • July 23, 2008 at 11:02 am

    #194323

    Hi All,

    I wants to know how Xml helps for inserting array of data in table and what is other uses of xml in sql server 2005 version??

    and also explain me how xml is having better uses in sql server 2005 version??

    Thanks in advance,

    Milu.:)

  • July 23, 2008 at 12:35 pm

    #847293

    You are asking a very general question. How does it help? It reduces round trips, but that may or may not be what makes the most sense.

    You can learn a bit by searching on XML and arrays:

    http://www.sqlservercentral.com/articles/Advanced+Querying/thearrayinsqlserver2000/1886/

  • July 23, 2008 at 11:14 pm

    #847521

    Milu,:)

    Yes, Obviously...

    I can guide you the XML and Array comparison ...

    In your general Programming language the Array is just group of data following subscript number starts from 0, which gives you the position of an elements. Like same If you store the data in XML, the tag gives you the position and values as per the requirements..

    Like :

    Array:

    --------

    a,b,c

    0 1 2

    In Xml: [ replace " ] " with " > " ]

    ---------

    <Data]

    <d1] a</d1]

    <d2]b</d2]

    <d3]c</d3]

    </Data]

    This is how Xml Helps to identify the data. its benefits is user defined tags..

    The beauty of XML is by Single Inserts statements you can Inserts Multiple Records...and also so many advantage has added by Microsoft....

    I can say you 1st study the Concepts of XMl and What is its advantage and Why it added with SQL Server then Try to implements it...

    Cheers!

    Sandy.

    --

  • July 24, 2008 at 10:50 am

    #847950

    Thanks steve & sandy...

    Nice explanation sandy..I am impressed..

    as per you, I will go through this and prepare for the XML..

    luv's

    Milu..:)

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply