Convert row data to XML file format in SQL Server

Ways to convert row data from a table in SQL Server to an XML-formatted file:

Syntax: SELECT * FROM table name for XML path (name of parent node in XML file)

Case:

Create a User basic information table under the Movie Database [Userinfoes]:

Use [Movie]
GO
CREATE TABLE [dbo]. [Userinfoes] (
[UserId] [INT] IDENTITY (*) not NULL PRIMARY KEY,
[UserName] [varchar] () not NULL,
[Age] [INT] Not NULL,
[Phone] [varchar] () NULL
)
GO

Insert data into the User Information table [Userinfoes]:

INSERT into [Movie]. [dbo]. [Userinfoes] ([Username],[age],[phone])
Select ' Zhang San ', 20,0728-6254245 Union
Select ' John Doe ', 20,13125689541
GO

To convert a specified row of data in the User Information table into XML format:

Select Username,age from Userinfoes where userid=8 for XML path (' user ')

Convert row data to XML file format in SQL Server