auto increment

[vin]

Hi,
Can anyone tell me how can I set autoincrement field via SQL Statement or ADO.

Thanks

[Lothar Haensler]

in SQL server, you can use the
SET IDENTITY_INSERT tablename ON|OFF
statement.
It allows explicit values to be inserted into an indentity column.

[vin]

Thanks Lothar!

You keep these forums alive.

if you are using oracle then all you need to do is create a sequence and say in you sequel insert statement to geta an auto incremented value each time you insert a data in the columm...

if you are using oracle then all you need to do is create a sequence and say<> in you sequel insert statement to geta an auto incremented value each time you insert a data in the columm...