Post reply

add serial number coloum and sno 1to 40000

  • March 28, 2014 at 2:29 am

    #305826

    add sno 1 to end of the coloum

    i have table like ...

    400000 laks rows in my table

    name address id location

    raju hyd 6789 hyd

    vamshi vizag 9876 hashinapur

    o/p like

    i want insert sno coloum and sno 1 to 400000

    sno name address id location

    1 raju hyd 6789 hyd

    2 vamshi vizag 9876 hasthinapur

    3

    4

    5

    6

    ..

    .

    .

    .

    .

    40000

  • March 28, 2014 at 4:40 am

    #1701023

    alter table table add slno bigint identity(1,1)

    regards

    J Siva Kumar

  • March 28, 2014 at 4:52 am

    #1701025

    alter table table_name

    add sr_no bigint identity(1,1)

    Mark as useful if it works.

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

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