[Webinar] Streamline your web hosting managementRegister Today

x
?
Solved

SQL to copy a record and insert it using a specified new primary key

Posted on 2011-02-16
2
Medium Priority
?
341 Views
Last Modified: 2012-06-22
I have an 80 coluimn table with lots of records and the Primary key is a column named OrderNum (and is NOT an identity field). I need to insert a new record with all identitical values as an existing record based on the OrderNum, except obviously the OrderNum can't be the same, so I need to assign the newly inserted OrderNum.

What would be the best SQL statement to accomplish this?
Let's say the record I need to copy is OrderNum=100500
and I need to assign the new record Ordernum=101880
0
Comment
Question by:bobPUNKbob
2 Comments
 
LVL 26

Accepted Solution

by:
tigin44 earned 2000 total points
ID: 34911368
try a syntax like this

INSERT INTO yourTable (OrderNum, col1, col2,....)
SELECT 101880, col1, col2,....
FROM yourTable
WHERE OrderNum = 100500
0
 

Author Closing Comment

by:bobPUNKbob
ID: 34912168
Thanks!
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Microsoft provides a rich set of technologies for High Availability and Disaster Recovery solutions.
This article will show a step by step guide on how to mask column values in Oracle 12c using DBMS_REDACT full redaction option. This option is available on licensed Oracle Enterprise edition as part of Oracle's Advanced Security.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Via a live example, show how to shrink a transaction log file down to a reasonable size.
Suggested Courses

590 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question