<div>
Insert Into TableA (Col1, Col2, Col3....)<br />
Select Col1, Col2, Col3...<br />
From TableB
</div>


Insert Into TableA (Col1, Col2, Col3....)
Select Col1, Col2, Col3...
From TableB

<div>
thanks....so there isn't a way to use a WILDCARD Character...like<br />
<br />
INSERT INTO TableB ( col1, col2, col3 .... )<br />
&nbsp; SELECT * &nbsp; &lt;---------- ???<br />
&nbsp; &nbsp;FOM tableA<br />
&nbsp; &nbsp;WHERE ...
</div>


thanks....so there isn't a way to use a WILDCARD Character...like

INSERT INTO TableB ( col1, col2, col3 .... )
  SELECT *   <---------- ???
   FOM tableA
   WHERE ...

<div>
if both tables are REALLY identical, then you could do this:<br />
<br />
INSERT INTO TableB <br />
&nbsp; SELECT *<br />
&nbsp; &nbsp;FOM tableA<br />
&nbsp; &nbsp;WHERE ...<br />
<br />
note that it is usually dangerous for be used in production...
</div>


if both tables are REALLY identical, then you could do this:

INSERT INTO TableB
  SELECT *
   FOM tableA
   WHERE ...

note that it is usually dangerous for be used in production...

<div>
Ok..I would be running this SQL script manually...and the data tables are IDENTICAL in column names etc...<br />
<br />
Thanks for the information....
</div>


Ok..I would be running this SQL script manually...and the data tables are IDENTICAL in column names etc...

Thanks for the information....

<div>
<div class="content wysiwyg-content">
Experts:<br />
<br />
Can I get the syntax for entering TableA into TableB. TableA contains the historical data and TableB has new data that needs to be populated INTO TableA.<br />
<br />
Identical Columns....datatypes...etc<wbr />..etc..<br />
<br />
Thanks<br />
<br />
MikeV
</div>
</div>


Experts:

Can I get the syntax for entering TableA into TableB. TableA contains the historical data and TableB has new data that needs to be populated INTO TableA.

Identical Columns....datatypes...etc..etc..

Thanks

MikeV

INSERT contents of one table...into an existing table....?

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.