sql server (alternate): Copy data from one table to another table with change in identity column values -- sql server (alternate)

Copy data from one table to another table with change in identity column values

satish
8/20/2007 9:21:30 AM

sql server (alternate): HI,
I have a table
Create table test(a int identity(1,1), b int)
insert into test(b) values(12)
insert into test(b) values(30)
insert into test(b) values(65)
insert into test(b) values(78)
insert into test(b) values(36)

o/p
a b
1 12
2 30
3 65
4 78
5 36

i need to copy the table into another table with creating the new
table
we had a option
select * into newtable from oldtable
here the data in the oldtable will e copied to new table without
creating new table
but i need to copy the data as shown below with out creating new
table
o/p
a b
11 12
12 30
13 65
14 78
15 36

Thanks,
Satish

Re: Copy data from one table to another table with change in identity column values

Roy Harvey
8/20/2007 1:09:37 PM

If I understand your question, you want to insert the data from table
test into an already existing table.

INSERT existingtable
SELECT a, b
FROM test

Roy Harvey
Beacon Falls, CT

On Mon, 20 Aug 2007 09:21:30 -0000, satish
[quoted text, click to view]

Re: Copy data from one table to another table with change in identity column values

Erland Sommarskog
8/20/2007 9:54:50 PM

Roy Harvey (roy_harvey@snet.net) writes:
[quoted text, click to view]

I guess it should be:

INSERT existingtable
SELECT 10 + a, b
FROM test

since Salish wanted to change the values.

--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at

Re: Copy data from one table to another table with change in identity column values

Roy Harvey
8/20/2007 10:06:08 PM

On Mon, 20 Aug 2007 21:54:50 +0000 (UTC), Erland Sommarskog
[quoted text, click to view]

Thanks for catching that, Erland.

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server (alternate) group.