|
Posted by ZeldorBlat on 10/02/08 11:56
mutem...@gmail.com wrote:
> 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.
Allow me to reiterate my previous response: create an auto-incrementing
identity column in the destination table, then do an insert.
Navigation:
[Reply to this message]
|