A `SELECT` query returns results as a rowset. You can optionally retrieve formal results of a SQL query as XML by specifying the `FOR XML` clause in the query. The `FOR XML` clause can be used in ...