SET QUOTED_IDENTIFIER ON
GO
declare @data XML = (select OBJECT_ID, name
FROM sys.objects
FOR XML RAW('objects'))
select @data as '@data'
SELECT OBJECT_ID = T.item.value('@OBJECT_ID', 'int'),
name = T.item.value('@name', 'sysname')
FROM @data.nodes('/objects') AS T(item)