export data by MS-SQL

Insert Into

           TableName_1

       (column_1, column_2......)

         Values

      select column_1, column_2..... form TableName_2

 

 

 

Update

     set tablename_1.column_1=tablename_2.column_1

         From

     tablename_1 Inner Join tablename_2 on tablename_1.column=tablename_2.column