Import XML into SQL Server

Question

I am trying to insert a XML into a SQL Server table, but I get an error:

Msg 2205, Level 16, State 1, Line 10
XQuery [value()]: ")" was expected.

Code:

 DECLARE @XML XML = '<list>
    <object Index="0"   Type="0"    Name="obj1" Level="6" />
    <object Index="1"   Type="0"    Name="obj2" Level="9"    />
</list>'
INSERT INTO dbo.testt(test1, test2, test3, test4)
SELECT
    test1 = Events.value('@Index','int'),
    test2 = Events.value('@Type','varchar'),
    test3 =Events.value('@Name','varchar'),
    test4 =Events.value('(@Level','int')
FROM
 @XML.nodes('/list/object') AS testtt(Events)

Thank you!

Donal · Accepted Answer · 2015-03-31 13:59:13Z

3

You have a ( before @Level

test4 =Events.value('(@Level','int')

should be:

test4 =Events.value('@Level','int')

answered Mar 31, 2015 at 13:59

Donal

33.2k10 gold badges69 silver badges75 bronze badges

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

Collectives™ on Stack Overflow

Import XML into SQL Server

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related