• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 701
  • Last Modified:

problem in executing "sp_xml_preparedocument" stored procedure


I am executing this below code in sql queryanalyzer .It returns the null value.

Here is my code

 exec sp_xml_preparedocument @hDoc OUTPUT,'<Shops><Shop><col1>01000200</col1><col2>49.035792</col2><col3>-122.338480</col3><col4>ADDRESS</col4></Shop></Shops>'
Select col1,col2,col3,col4
 FROM OPENXML(@hDoc, 'Shops/shop')  
 WITH (col1 varchar(10),col2 varchar(50),col3 varchar(50),col4 varchar(50))

col1   col2  col3  col4
null  null    null    null

But it should return the value of col1,col2,col3,col4.

Could anyone help me for this.

1 Solution
Anthony PerkinsCommented:
Try it this way:

Select      col1,
FROM      OPENXML(@hDoc, 'Shops/Shop') WITH (
            col1 varchar(10) 'col1',
            col2 varchar(50) 'col2',
            col3 varchar(50) 'col3',
            col4 varchar(50)'col4')
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now