|
Posted by ZeldorBlat on 10/02/72 11:56
mutemode@gmail.com wrote:
> Help again please,
> I need to insert rows into a table from another table. The tables are
> identical column wise except the table im inserting from does not have
> a primary key value. On insert I need to generate a primary key that
> is consecutive based on the table im inserting into. Also the table im
> inserting into does not have a identity column. Much appreciated.
Then create an auto-incrementing identity column in the destination
table and insert away.
Navigation:
[Reply to this message]
|