The question itself is quite odd, you don't show XML data in SQL Server, you store or modify it. You can use client applications to show the data.
To get the idea about XML support in SQL Server I suggest reading through
Implementing XML in SQL Server[
^]. It also contains a section for
Sample XML Applications[
^]