• I try but its not work

    SELECT a.* from @address a

    where a.AddressID = 9

    FOR XML path('Addresses'), ELEMENTS XSINIL