SQLServer:Namespaces preventing access to query data
- by Brian
Hi
A beginners question, hopefully easily answered. I've got an xml file I want to load into SQLServer 2008 and extract the useful informaiton.
I'm starting simple and just trying to extract the name (\gpx\name). The code I have is:
DECLARE @x xml;
SELECT @x = xCol.BulkColumn
FROM OPENROWSET (BULK 'C:\Data\EM.gpx', SINGLE_BLOB) AS xCol;
--…