如何实现Table对Table进行insert或update command?

CREATE TABLE #TempA
(
        [ID] [varchar](512) NULL,
        [Desc] [varchar](512) NULL
)

INSERT INTO #TempA([ID], [Desc]) VALUES('A', 'Apple');
INSERT INTO #TempA([ID], [Desc]) VALUES('B', 'Ball');
INSERT INTO #TempA([ID], [Desc]) VALUES('C', 'Car');

SELECT * FROM #TempA

--------------------------------------------------------------

CREATE TABLE #TempB
(
        [ID] [varchar](512) NULL,
        [Desc] [varchar](512) NULL
)

INSERT INTO #TempB([ID], [Desc]) VALUES('A', 'Apple');
INSERT INTO #TempB([ID], [Desc]) VALUES('B', 'Bear');
INSERT INTO #TempB([ID], [Desc]) VALUES('C', 'Cat');
INSERT INTO #TempB([ID], [Desc]) VALUES('D', 'Dog');
INSERT INTO #TempB([ID], [Desc]) VALUES('E', 'Eagle');

SELECT * FROM #TempB

--------------------------------------------------------------

DROP TABLE #TempA
DROP TABLE #TempB