Reg. Loading records from same table

  • Hello...

    I'm new to sql server, i have a small question. Please help me

    I have a table like this

    Id Value

    1 101

    2 201

    3 301

    4 401

    ............ like this i have 100k rows

    My task is add to new columns to the same table as NewId, NewValue and load the same data...My table should be like this

    Id Value NewId NewValue

    1 101 1 101

    2 201 2 201

    3 301 3 301

    Thanks in advance....

  • Anyways i got that thanks.....

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply