Hiii,i have a table it contains 1000 rows,now i like to add a new column as null column.
now i want to update this column numbers from 1,2 --1000.
Is there any method?
if any one know give me example
thanks
Printable View
Hiii,i have a table it contains 1000 rows,now i like to add a new column as null column.
now i want to update this column numbers from 1,2 --1000.
Is there any method?
if any one know give me example
thanks
Does the order of the rows matter??
Add new column to the table.
Write a curosr loop to update this column using a counter.
HTH
Sanjay
hii, i want order 1 t0 1000.
because this table contains some other columns.
this column become serialno column.
so i must eneter values from 1 to 1000.
if possble modify the mine.
thanks
Hi,
Why don't u define a sequence on ur table if u want give serialno from 1,2..1000 to ur table rows?
Raju