SQL Server, how to merge two columns into one column?

Try this:

SELECT TABLE_SCHEMA + '.' + TABLE_NAME AS ColumnZ FROM information_schema.tables

sql sql-server calculated-columns

SELECT CONCAT(TABLE_SCHEMA, '.', TABLE_NAME) AS ColumnZ FROM information_schema.tables

sql sql-server calculated-columns

This code work for you try this....

SELECT Title,FirstName,lastName, ISNULL(Title,'') + ' ' + ISNULL(FirstName,'') + ' ' + ISNULL(LastName,'') as FullName FROM Customer

CodeHunter