how to add column data in MSSQL

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

0

Dharmesh Sharma15y ago

i know to add lick this

SELECT (col1+col2+col3......................)

but i need some other idea like to add by trigger and more

0

Dharmesh Sharma15y ago

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

0

Santhosh N15y ago

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

0