numbering sequence

[chanchal]

I have to insert number sequentially in the sequence table. i don't want to use auto number instead of i want to use query to insert number. In the serial no field number should be inserted sequentially like 1,2,3,4,5 and also it should go to frist record then inserted number sequencially.
Serial no code name
1 fdsfsdfsdf erewrwr
2 lkdjflsdjf lkjlkdsjf jl
3 dfdslfjslfj lkjkljlkdsjf
4 dfdfdfsdsd fdfdsfdsfsdf
5 dsfdfdsf fdfdsfsf
6 fdfdsfdsf dsffsdfsdf
7 dffsdd dsfdsfsdf
8 dsfsdfdsf dsfsdfsdf

is it possible with query please reply soon.

 

[SQL_Hell]

Hi,

Before we get started, what is wrong with autonumber? Works for me