FOR XML AUTO

...in T-SQL this will take a SELECT statement and return it as XML. This has some notes on as much.

 
 

FOR XML PATH('YourNameHere')

...in contrast specifies a specific type of XML formatting.

 
 

FOR XML PATH('YourNameHere'), ROOT('Taco')

...moreover creates a root XML node of Taco to wrap the other nodes.