See Re: Record ID generator question Message #611104

>I've got the follow UDF to get the next invoice number in a VFP table called DocsNumbers.
>

>LOCAL lnNext
>
>SET MULTILOCKS ON
>SET REPROCESS TO 0 Automatic
>
>SELECT DocsNumbers
>WAIT WINDOW "Gettign document number..." NOWAIT
>RLOCK()
>lnNext = DocsNumbers.invoice +1
>REPLACE DocsNumbers.invoice WITH lnNext
>TABLEUPDATE(.T.)
>UNLOCK IN DocsNumbers
>WAIT CLEAR
>
>RETURN lnNext
>

>
>How can I do this in T-SQL using a SQL server database ?
>
>T.I.A.