To concatenate text from multiple rows into a single string in SQL Server, you can use the STRING_AGG function for SQL Server 2017 and later. This simplifies the process by allowing you to specify the delimiter and directly concatenate the values. For older versions, use the FOR XML PATH method, which involves XML functions and is more verbose. Both methods achieve the same result of concatenating values from multiple rows.