I am working with sybase ASE 15.5 version. I have to create a table with a primary key from one table and an identity column to generate an identity value for the primary key of the main table like this
select newid = identity(10), id into newtb1 from table1
And I have to do this for all the source tables. The problem i face here is when I am doing this the identity column is getting generated newly everytime. For newtb1 if the newid column is from 1 to 100, for the next table newtb2 i want the identity column from 101. Is there any way of setting the initial value of the identity column and then do a select?
Please help me with this.