"Andrew J. Kelly" <sqlmvpnooospam@shadhawk.com> wrote in message
news:eiH3G0ThDHA.2420@TK2MSFTNGP10.phx.gbl...
> You use the IDENTITY function. You can find more info in BooksOnLine on
> how to use it.
>
> --
>
> Andrew J. Kelly
> SQL Server MVP
>
>
> "VideoSmeden" <software@picsign.dk> wrote in message
> news:%23PYEUeThDHA.524@tk2msftngp13.phx.gbl...
> > Hi
> > Please help me URGENT
> > How do i make an tableField with a
> > Auto-Incr, the same like in an access DB where it's
> > called AutoNumber
> >
> > Thanx in advance
> > __________________________________________________________________
> Flemming
> > Paulsen ICQ#: 270065050 Current ICQ status: + More ways to contact me
> > __________________________________________________________________
> >
> >
>
>

"VideoSmeden" <software@picsign.dk> wrote in message
news:%23PYEUeThDHA.524@tk2msftngp13.phx.gbl...
> Hi
> Please help me URGENT
> How do i make an tableField with a
> Auto-Incr, the same like in an access DB where it's
> called AutoNumber
>
> Thanx in advance
> __________________________________________________________________
Flemming
> Paulsen ICQ#: 270065050 Current ICQ status: + More ways to contact me
> __________________________________________________________________
>
>

"Andrew J. Kelly" <sqlmvpnooospam@shadhawk.com> wrote in message
news:eiH3G0ThDHA.2420@TK2MSFTNGP10.phx.gbl...
> You use the IDENTITY function. You can find more info in BooksOnLine on
> how to use it.
>
> --
>
> Andrew J. Kelly
> SQL Server MVP
>
>
> "VideoSmeden" <software@picsign.dk> wrote in message
> news:%23PYEUeThDHA.524@tk2msftngp13.phx.gbl...
> > Hi
> > Please help me URGENT
> > How do i make an tableField with a
> > Auto-Incr, the same like in an access DB where it's
> > called AutoNumber
> >
> > Thanx in advance
> > __________________________________________________________________
> Flemming
> > Paulsen ICQ#: 270065050 Current ICQ status: + More ways to contact me
> > __________________________________________________________________
> >
> >
>
>

"William (Bill) Vaughn" <billvaRemoveThis@nwlink.com> wrote in message
news:eUEYysUhDHA.1272@TK2MSFTNGP09.phx.gbl...
> Ah, it's better to use the SCOPE_IDENTITY() function instead of the
> @@IDENTITY global variable.
>
> --
> ____________________________________
> Bill Vaughn
> MVP, hRD
> www.betav.com
> Please reply only to the newsgroup so that others can benefit.
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> __________________________________
>
> "Andrew J. Kelly" <sqlmvpnooospam@shadhawk.com> wrote in message
> news:eiH3G0ThDHA.2420@TK2MSFTNGP10.phx.gbl...
> > You use the IDENTITY function. You can find more info in BooksOnLine
on
> > how to use it.
> >
> > --
> >
> > Andrew J. Kelly
> > SQL Server MVP
> >
> >
> > "VideoSmeden" <software@picsign.dk> wrote in message
> > news:%23PYEUeThDHA.524@tk2msftngp13.phx.gbl...
> > > Hi
> > > Please help me URGENT
> > > How do i make an tableField with a
> > > Auto-Incr, the same like in an access DB where it's
> > > called AutoNumber
> > >
> > > Thanx in advance
> > > __________________________________________________________________
> > Flemming
> > > Paulsen ICQ#: 270065050 Current ICQ status: + More ways to contact me
> > > __________________________________________________________________
> > >
> > >
> >
> >
>
>