How to Concatnate 2 column values to make one column value in SQL-Server?

Answer:

Using '+' sign or Concat in-built function we can Concatnate 2 column values as shown below:-

select(employee_firstname + ' ' + employee_lastname) AS Name from employee_master;

select Concat(employee_firstname , ' ' ,employee_lastname) AS Name from employee_master;