Hi Guys - This should be an easy one but need to confirm.
I need to alter a table and create Auto Number based on Order By ASCENDING a field which is a 13 digit numbers.
I normally use:
Alter Table [TableNAME]
add AutoNum Numeric(5,0) identity
But the above does not like ORder By statement,.
Please guide as soon as possible.
Thanks in Advance