Concatenating two columns in SQL Server

How to concatenate two columns in the result set in SQL Server?

It's too simple. Check the below script,

drop table venkat_table
go
create table venkat_table (id int,val varchar(100),val1 varchar(100))
insert into venkat_table values(1,'Venkat','Prabu')
select ID, val +' '+ val1 as name from venkat_table

Cheers,
Venkatesan Prabu .J