How would you append to an existing table using ALL of the values from a table? As example:
Table A has (col1,col2,col3).
Table B has (col1,col2,col3) with 50 records.
How would you take all 50 records from Table B and append them to Table A (assuming the data types and lengths are the same)?
DATABASE SYSTEM: SQL Server 2000