This is the easiest way, though it may not work for what your actual query is but...

-- Test table with some rubbish data

DECLARE @test-2 TABLE

(

Names [varchar](20)

)

INSERT INTO @test-2

SELECT 'Simon'

-- Query returns but with XML_<GUID> alias

SELECT (SELECT

Names

FROM

@test-2 t

FOR XML PATH ('Test') ) as Test