SQL Server converts the data of a field into a string using a statement. SQL Server

SQL Server converts the data of a field into a string using a statement. SQL Server

For example, data column Name
Copy codeThe Code is as follows:
Name
A
B
C
D

Final Result
Copy codeThe Code is as follows:
A * B * c * d *

Declare @ test table (namevarchar (10 ))
Insert into @ testvalues ('A'), ('B'), ('C'), ('D ');

Select distinct
(Select cast (name asvarchar (2) + '*' from @ test for xml path ('') as name from @ test

Output result:
Copy codeThe Code is as follows:
(4 row (s) affected)
Name
--------------------------------------------------
A * B * c * d *
(1 row (s) affected)