Login | Register   
LinkedIn
Google+
Twitter
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


Tip of the Day
Language: SQL Server
Expertise: Beginner
Feb 1, 1999

Copying data

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'
DevX Pro
 
Comment and Contribute

 

 

 

 

 


(Maximum characters: 1200). You have 1200 characters left.

 

 

Sitemap
Thanks for your registration, follow us on our social networks to keep up-to-date