how to merge table in sql server?
how to merge table in sql server?
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Jignesh TrivediPosted May 7, 2013, 11:29 PM
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 (x,y,z)
select x,y,z from tableB
this will merge data of table B into A
hope this will help you.