USE pubs
GO

WITH XMLNAMESPACES('http://example.org/person/names' as nam)
SELECT au_id AS [@authorid],
       au_fname AS [nam:name/nam:firstname],
       au_lname AS [nam:name/nam:lastname]
  FROM authors
  WHERE au_id > '998'
  FOR XML PATH
GO
