| Author |
auto generate Number
|
|
|
| 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@googlemail.com 2006-12-11, 6:57 pm |
| 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
G wrote:
> 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
| |
| Mike Brind 2006-12-11, 6:57 pm |
| 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.
--
Mike Brind
<anthonybrough@googlemail.com> wrote in message
news:1165701100.541225.214210@n67g2000cwd.googlegroups.com...
> 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
>
> G wrote:
>
>
|
|
|
|