in vfp i do :
replace all myfield with recno()

and the command re-number the field.

how can i do it in sqlserver ?