Insert Data in Table

Copy data for Table1 to Table2  by Same structure

INSERT

INSERT INTO table2 (column1, column2, column3, ...)

SELECT column1, column2, column3, ...

FROM table1

WHERE condition;

UPDATE

UPDATE     [GSTEST].[dbo].[OrgOrganize] SET     [GTEST].[dbo].[OrgOrganize].DefaultByArea = Org.DefaultByArea FROM    [GTEST].[dbo].[OrgOrganize] OrgTest INNER JOIN     [G].[dbo].[OrgOrganize] Org ON      OrgTest.OrganizeKey = Org.OrganizeKey;