Execute the following Microsoft SQL Server T-SQL script in SSMS Query Editor to list all addresses in XML format:

USE AdventureWorks

GO

SELECT [AddressID] AS 'AWAddressID',

       [AddressLine1],

       [AddressLine2],

       [City],

       [StateProvinceID],

       [PostalCode],

       [rowguid],

       [ModifiedDate],

       (SELECT [StateProvinceID],

               [StateProvinceCode],

               [CountryRegionCode],

               [Name],

               [TerritoryID]

        FROM   [AdventureWorks].[Person].[StateProvince] AS StateProvince

        WHERE  StateProvince.[StateProvinceID] = a.[AddressID]

        FOR XML AUTO, TYPE)

FROM   [AdventureWorks].[Person].[Address] AS a

FOR XML PATH ('AddressList')

Related article:

Exporting SQL Data as XML