Understanding the Optimal Approach to SQL Concat and Variable Assignment in SQL Server

How to Perform String Concatenation in PHP Using SQL Queries