Posted by satish on 08/20/07 09:21

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

• Next in forum: DOWNLOAD CRACKED 2007's SOFTWARE: ARCHICAD 11,UNIGRAPHICS NX5,SOLIDWORKS 2008,XSTEEL 13,AUTOCAD 2008
• Prev in forum: Re: SQL Profiler - SPID
• Thread view: Copy data from one table to another table with change in identity column values

[Reply to this message]