insert two column information into one column

Hi Ajay,

You can get this by using store procedure because in direct insert sql statement column is not allowed to insert. So try this.

CREATE PROCEDURE SPContact
@FName varchar(20),
@LName varchar(20)
As
Begin
insert into contact(Fname, Lname, ContactName) values(@Fname, @Lname, @Fname+@Lname)
end
exec spcontact @Fname='Shambhu', @Lname='Suman'


Regards,
Shambhu

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
 

just put simple query

insert into contacts values ('ajay','kalidindi',firstname+'-'+lastname)