how to merge table in sql server?

Question

Jignesh Trivedi · Answer

hi Are you looking for merge two table or Merge Statement for SQL server? if two table has same number of column with same datatype so it is possible. for example you have two table called table A and B Insert into tableA (xyz) select xyz from tableB this will merge data of table B into A hope this will help you.