1. Generating identity values without IDENTITY keyword
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, ...)
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.
insert into MyTable (pk,field1,field2, ...)
Is there any way to skip the temporary table creation?
Mario De Sousa Barrera
2. 16 bit and 32 bit open client
3. Overriding a default error message in SQL Server
4. RAIMA Is on the Internet
5. override the default value for datetime datatype in sql server 7.0
6. Running Paradox 3.5 on Novell 4.11.
7. Override defaults in inherited fields and tables
8. concatenate names in tables for web addresses
9. Re : overriding default value in inherited column (+
10. Re : overriding default value in inherited column (+ set_value function)
11. overriding default value in inherited column
12. Overriding the default SQL cursor
13. Overriding the default logon screen in Forms 4.5