SQLXML: OpenXML with type of Openrowset?

Last Post 28 Apr 2007 12:33 AM by SQLUSA. 1 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
dianagele
New Member
New Member

--
27 Apr 2007 10:27 AM
I have seen OPENXML examples that process XML as text
quote:

SELECT @MyXml = '< blahblahblah >'

But want to directly access the file as OPENROWSET.

Or is there a better method.
Desperate need of examples to get me on the right track.
SQLUSA
New Member
New Member

--
28 Apr 2007 12:33 AM
So with OPENROWSET you want to access
the XML file, line by line? Like you would see it in a Notepad?

Kalman Toth, Database Architect
SQL Server 2005 Training - http://www.sqlusa.com
You are not authorized to post a reply.

Acceptable Use Policy