DECLARE @xmlDoc NVARCHAR(MAX)
DECLARE @handle INT

SET @xmlDoc =
'<?xml version="1.0" encoding="utf-16"?>
<Data xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
<FileInfo>
<Copyright>Me</Copyright>
</FileInfo>
<Names>
<Name>
  <NameID/>
  <Type>G</Type>
  <Name>Special Bear</Name>
</Name>
</Names>
</Data>'

EXEC sp_xml_preparedocument @handle OUTPUT, @xmlDoc

-- Execute a SELECT statement that uses the OPENXML rowset provider.
--INSERT INTO dbo.stgArtists
SELECT  NameID ,
        Type ,
        Name 
   FROM OPENXML (@handle, '/Data/Names/Name',2)
  WITH (NameID  varchar(255),
       [Type] varchar(255),
       [Name] varchar(255))

EXEC sp_xml_removedocument @handle

NameID  Type   name
          G    Special Bear

SELECT  NameID ,
        Type ,
        Name 
   FROM OPENXML (@handle, '/Data/Names/Name',3)
  WITH (NameID  varchar(255) 'text()',
       [Type] varchar(255),
       [Name] varchar(255))