Read all records from an XML OData service table

Gets all rows from a table when the service uses XML. Supply TableName in WITH to identify the entity set (e.g. MyTable).

SELECT * FROM read_data_xml WITH(TableName='MyTable')