Re: Copy records from one table to another
From: Tom Moreau (tom_at_dont.spam.me.cips.ca)
Date: 04/29/04
- Next message: Richard J: "RE: Copy records from one table to another"
- Previous message: David Chase: "WHERE clause problem"
- In reply to: Ed: "Copy records from one table to another"
- Next in thread: Richard J: "RE: Copy records from one table to another"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 29 Apr 2004 08:30:53 -0400
Try:
insert TableB
select
*
from
TableA
where
...
-- Tom --------------------------------------------------------------- Thomas A. Moreau, BSc, PhD, MCSE, MCDBA SQL Server MVP Columnist, SQL Server Professional Toronto, ON Canada www.pinnaclepublishing.com/sql "Ed" <xx@xx.com> wrote in message news:uxO0TPeLEHA.3292@TK2MSFTNGP11.phx.gbl... I have two identical tables (TableA has data, TableB is empty) Using SQL, I want to select a range of records from TableA and insert them into TableB. Can someone help. Thanks Ed
- Next message: Richard J: "RE: Copy records from one table to another"
- Previous message: David Chase: "WHERE clause problem"
- In reply to: Ed: "Copy records from one table to another"
- Next in thread: Richard J: "RE: Copy records from one table to another"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
