I have a sql server table say test1 with 20-25 columns.
I have another table test2 with say 25-30 columns.
There are around 20 matching columns between the two.
Now I want to update test2 from test1 data (only matching columns need to be updated) based upon the ID column which is common to both tables.
I need a generic query where the need to specify column names is not there.
Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.