Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

How to insert values in a particular column ONLY?

Discussion in 'Information Technology' started by arunachalam.arcot@gmail.com, Jul 28, 2006.

  1. arunachalam.arcot@gmail.com

    arunachalam.arcot@gmail.com
    Expand Collapse
    Guest

    I have a table, where i need to insert values only for one particular
    column and the other columns will be manually or will be populated
    through other queries. I'm kind of having difficulty with this. I tried

    "Insert into " with select statements and also Select Into, both does
    not solve this, because they append a new row insted of inserting
    values into
    a specific row. Any help will be highly appreciated.

    Thanks
     
  2. Loading...


  3. SusanV

    SusanV
    Expand Collapse
    Guest

    UPDATE yourtable(fieldname) SET fieldname = "Whatever"

    --
    hth,
    SusanV

    <arunachalam.arcot@gmail.com> wrote in message
    news:1150389012.444173.119700@r2g2000cwb.googlegroups.com...
    >I have a table, where i need to insert values only for one particular
    > column and the other columns will be manually or will be populated
    > through other queries. I'm kind of having difficulty with this. I tried
    >
    > "Insert into " with select statements and also Select Into, both does
    > not solve this, because they append a new row insted of inserting
    > values into
    > a specific row. Any help will be highly appreciated.
    >
    > Thanks
    >
     

Share This Page