update single column
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: update single column

  1. #1
    Join Date
    May 2002
    Posts
    232
    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
    kavitha

  2. #2
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    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

  3. #3
    Join Date
    May 2002
    Posts
    232
    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
    kavitha

  4. #4
    Join Date
    Jul 2002
    Posts
    14

    define a sequence

    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width