store XML file data into a SQL XML datatype field

Question

Do I store this XML file data into a SQL XML datatype field?

How do I write to it without writing into a XML file?

This should give you a good starting point: XML Support in Microsoft SQL Server 2005 — Joe Stefanelli
– Joe Stefanelli, Commented Oct 13, 2011 at 13:37

score 2 · Accepted Answer · 2011-10-13 14:25:42Z

2

Its not clear to me what you want. But you can store the xml file into a xml field and manipulate this field whatever you want.

Oracle database allows you to create a table based on a xml file, and changes on the table reflect over the xml file, you cant do that in SQL Server.

Anyway, you can manipulate a xml field like this:

declare @friends xml

set @friends =
'
<friends>
    <friend>
        <id>3</id>
    </friend>
    <friend>
        <id>6</id>
    </friend>
    <friend>
        <id>15</id>
    </friend>
</friends>
'

select
    template.item.value('.', 'bigint') as id
from @friends.nodes('//friends/friend/id') template(item)

edited Oct 13, 2011 at 14:25

answered Oct 13, 2011 at 13:39

user989818

Sign up to request clarification or add additional context in comments.

Comments

Shivprasad Koirala · Accepted Answer · 2011-10-13 14:30:34Z

0

If you want to store in SQL Server better use the XML data type as you get advantage of checking the type with XSD schema.

answered Oct 13, 2011 at 14:30

Shivprasad Koirala

28.9k8 gold badges88 silver badges75 bronze badges

Collectives™ on Stack Overflow

store XML file data into a SQL XML datatype field

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related