Hi!
I am inserting data using XML in sql server.
Now, some data in the XML has the same Value as to the data in the table where it will be inserted..
For instance: i have 2 columns (Identity, Firstname, Lastname)
Identity Firstname Lastname
1 vinci vinci
2 name name
Now, in my XML:
i have
<data>
<name fname="vinci" lname="icniv"/>
<name fname="othernam e" lname="othernam e">
</data>
i will insert that data in my XML, but notice that there is a data "vinci".
what i want to do is, not to anymore go on to insert the vinci fname in my xml to the table..
is it possible to disregard it?
tnx for your help!
cheers!
I am inserting data using XML in sql server.
Now, some data in the XML has the same Value as to the data in the table where it will be inserted..
For instance: i have 2 columns (Identity, Firstname, Lastname)
Identity Firstname Lastname
1 vinci vinci
2 name name
Now, in my XML:
i have
<data>
<name fname="vinci" lname="icniv"/>
<name fname="othernam e" lname="othernam e">
</data>
i will insert that data in my XML, but notice that there is a data "vinci".
what i want to do is, not to anymore go on to insert the vinci fname in my xml to the table..
is it possible to disregard it?
tnx for your help!
cheers!