how to add column data in MSSQL

Question

hi i have one table and in this 30 column and empid now i want to add these column data how i do i dont get any idea plz give me code n idea to add every column on the basis of empid

Suthish Nair · Answer

Hi Dharmesh Still we are not able to understand your posted query. Please explain the problem in detailed you facing and what the query is all about. So we can help you. If your looking for copying data from table1 to table2 then like this.. insert into table1 select * from table2

Dharmesh sharma · Answer

i know to add lick this SELECT (col1+col2+col3......................) but i need some other idea like to add by trigger and more

Dharmesh sharma · Answer

no this is not my question n answer i wana add data of column of one table and insert data to in this table to another column

Santhosh N · Answer

If your question is to add data from one table to other in sql server then you can do this using insert and select statement as below INSERT INTO targetTable (col1  col2 col3... ) SELECT col1  col2 col3... FROM sourceTable WHERE conditionIfRequired