combine results from two columns in ms sql code example

Example: combine results from two columns in ms sql

// SQL Combine results from two columns
select column1 + ' ' + column2 as twoInOne from yourTable