Is it possible to use variable for identity seed?

• Bengt

  Mr or Mrs. 500

  Points: 569

  More actions

  March 25, 2003 at 11:46 pm

  #101417

  I would like to pick a integer value from another table and use that value (+1) as the startvalue (the seed value) when adding an indentity column to an already existing table, something like:

  ALTER TABLE aa_individ

  ADD [actno] [int] IDENTITY (@startno, 1) NOT NULL

  Is this possible somehow when using SQL Server 7 (the above does not seem to work)?

• Chris Hedgate

  One Orange Chip

  Points: 25041

  More actions

  March 26, 2003 at 3:25 am

  #452162

  You can run the SQL statement dynamically and concatenate the variable into the statement, that way it would work. Why do you want to do this?

  --

  Chris Hedgate @ Apptus Technologies (http://www.apptus.se)

  http://www.sql.nu

  --
  Chris Hedgate http://www.hedgate.net/
  Contributor to the Best of SQL Server Central volumes
  Articles: http://www.sqlservercentral.com/columnists/chedgate/