Select as a XML MSSQL

In Mssql you can get select result as XML by using following TSQL statement
SELECT * FROM TableName FOR XML path, root;