xquery on data from another server

• Cougar Leung

  Newbie

  Points: 1

  More actions

  March 2, 2009 at 8:46 am

  #131416

  Hey guys,

  I am working on an application, which needs to query the xml document from another server (service) on the fly. I used XQuery in Oracle to query over HTTP. Does anybody know how to do that in SQL Server 2k5? I read through quite a few articles but almost all of them talked about xqueries within the same database, like from an xml column to a table. But I want to do this:

  select x.col1, x.col2

  from openxml('http://123/x');

  Any help or comment will be appreciated.

• Matija Lah

  SSCertifiable

  Points: 6429

  More actions

  March 6, 2009 at 5:17 am

  #954769

  You could use a SQLCLR procedure to access the external data source, or import the data into the database (e.g. using a scheduled SSIS package).

  ML

  ---
  Matija Lah, SQL Server MVP
  http://milambda.blogspot.com