by Hi!!
I want to insert several rows in an existent table. This table doesn't use
the IDENTITY keyword in the primary key field, but I would like to fill it
with increasing integer numbers.
The inserted rows come from a query from another table, and I found that
you can't assign a variable inside of a query to do something like this:
insert into MyTable (pk, field1, field2, ...)
from MyOtherTable
I have used the IDENTITY function (which is diferent from an Identity
property in a table), but then I have to use the INTO clause in the select
and create a temporary table.
into #TempTable
from MyOtherTable
insert into MyTable (pk,field1,field2, ...)
select *
from #TempTable
Is there any way to skip the temporary table creation?
--
Mario De Sousa Barrera
Eniac, C.A.
Caracas, Venezuela