Copying a record from one table to another

[Andrew Chalk]

What is the easiest way to copy a record from one table to another (with
identical structure)?

Regards

[Ray Higdon]

You mean into a new table? if so you can use select * into newtable from
oldtable (input your where statement)

To input into an existing table

insert into table1 select * from table2 (insert where statement)

HTH

Ray Higdon MCSE, MCDBA, CCNA

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!