how to merge 2 columns in sql code example
Example 1: add multiple columns to table sql
//Example
ALTER TABLE employees
ADD last_name VARCHAR(50),
first_name VARCHAR(40);
Example 2: concat two columns in sql server
select Convert(nvarchar(50),ID)+'-'+Convert(nvarchar(50),Year) as ID_Year from tablename