Can SQL 2005 Retrieve an XML Document and parse it?

Forum Moderators: open

Message Too Old, No Replies

Can SQL 2005 Retrieve an XML Document and parse it?

digitalv

7:08 pm on Sep 18, 2008 (gmt 0)

I'm trying to integrate intershipper with a custom cart and since the whole application has been written with stored procedures, I'd rather stay within that instead of having to go to the application to get the shipping rates.

So does anyone know if this can be done, and how I would do it? Meaning can I get data from a URL inside a stored procedure and parse the XML to get what I need from it?

digitalv

11:29 pm on Sep 18, 2008 (gmt 0)

Anyone know?

Ocean10000

1:24 pm on Sep 19, 2008 (gmt 0)

Sql Server 2005, includes the new native ability to process xml files along with the ability to use Dot.Net languages to make customized stored procedures. So yes is it possible. To process an xml stream in the stored procedure itself.

The following links shows some examples of using xml in SQL 2005.
Understanding the SQL Server 2005 XML Data Type [simple-talk.com]

What's New in FOR XML in Microsoft SQL Server 2005 [msdn.microsoft.com]

[edited by: Ocean10000 at 1:30 pm (utc) on Sep. 19, 2008]