XML and SQL Server Service Broker

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Cheryl - 11 Dec 2007 23:17 GMT

I am a newbie and I have a question. I have a service that will
receive a message that is in a XML format. I want to parse this xml
and put the data into a table. For instance if the xml looks like
this:

<Books>
<Title>New Beginning</Title>
<Cost>
<US>$43.00</US>
<CA>$63.00<CA>
</Cost>

I will have a table with columns named Title, US, and CA. The sp_
would parse out the tags and insert the correct data in the correct
column. Please let know me know if possible inside Service Broker.

Thanks.

Reply to this Message

Bob Beauchemin - 14 Dec 2007 18:54 GMT

Parsing XML is not a Service Broker function, but is a function that can be
accomplished using the nodes method on the XML data type.

Cheers,
Bob Beauchemin
SQLskills

>I am a newbie and I have a question. I have a service that will
> receive a message that is in a XML format. I want to parse this xml
[quoted text clipped - 13 lines]
>
> Thanks.

Reply to this Message