|
Posted by mutemode on 10/02/71 11:56
ZeldorBlat wrote:
> 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.
Sorry, both tables don't have an identity column.
Navigation:
[Reply to this message]
|