add serial number coloum and sno 1to 40000

• shashianireddy

  SSC Eights!

  Points: 914

  More actions

  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

• sivaj2k

  Ten Centuries

  Points: 1188

  More actions

  March 28, 2014 at 4:40 am

  #1701023

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

  regards

  J Siva Kumar

• gstarsaini

  Ten Centuries

  Points: 1010

  More actions

  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.