Auto Increment in a select stmt

• Bidec

  SSCommitted

  Points: 1666

  More actions

  March 24, 2004 at 9:18 am

  #76144

  Hi All,

  Can anyone please suggest me how to do a auto increment in a select statement.

  declare @x int

  set @x = 1

  select customerid,companyname, @x+1

   from northwind..customers

  This thing did not work for me, please suggest an alternative.

   

  Thanks.

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736063

  More actions

  March 24, 2004 at 9:48 am

  #500255

  Are you looking for a "row number" type thing?

  http://www.sqlservercentral.com/columnists/glarsen/sequentialnumbering.asp

• bhupinderd

  SSC Enthusiast

  Points: 149

  More actions

  March 24, 2004 at 9:27 pm

  #500355

  try @col1 = @col1 = col1+1

  where type = @01

• bhupinderd

  SSC Enthusiast

  Points: 149

  More actions

  March 24, 2004 at 9:38 pm

  #500356

  try this

  declare @col1 int

  update dbo.tablename

  set  @col1 = col1 =isnull(Col1,0)+1

  from   dbo.incrementBYone

  where anyfiled to identify the row = 1

  select @col1