Home » Tip Bank » Database Development » SQL » Transact-sql

Language: SQL Server
Expertise: Beginner

Feb 1, 1999

Question:
Is it possible to select only certain records from a table and copy those records to a new table?

Answer:
The easiest way to move only certain records from one table to another is to use the insert command with a select statement:

ex. insert into new_table (col_a, col_b, col_c, etc)
select col_a,col_b,col_c, etc
from old_table
where 
col_a = 'some value" and
col_b = 'whatever'