如何实现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
(
[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
以上是Table A和Table B
我要把所有Table B的资料，丢去Table A
那有什么办法做出insert或update command?
