I have an 'XML-hacker' solution:
declare @add1 xml
set @add1 = (SELECT a.* from @address a
where a.AddressID = 9
FOR XML path('Addresses'))
if @add1 is null
begin
set @add1 = cast('<Addresses>
<AddressID />
<AddressType />
<Address1 />
<Address2 />
<City />
<AgentID />
</Addresses>' as XML)
end
select @add1
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.