auto generate Number

[G]

Hello Firends

I want a sample code for developing an " auto genearte number " and want to
store in database.

Please if you find any code please send

Thanks in Advance
G

 

[anthonybrough]

Hi G

This would probably better posted to another group. however I have
found that it is better to allow the database to generate the the
number for you. If using access then try AUTONUMBER, if using oracle
then use a sequence to generate the number Not 100% sure about SQL but
I believe you can us @@Identity.

Reagrds


Tony

 

[Mike Brind]

SQL Server has an auto-increment field. @@Identity gets the value of the
identity column of the most recently added record using the same connection.