IDENTITY Function ?

• shaley1

  Valued Member

  Points: 64

  More actions

  May 16, 2002 at 5:14 am

  #79110

  I am using the IDENTITY function in a table conversion. I declare a int variable called

  @MAX_COMMENT. I set the value of @MAX_COMMENT

  to 65931.

  When I run my select into statement using

  IDENTITY(INT,@MAX_COMMENT,1) as comment_nbr

  the first value in comment_nbr is 7994648 ??

  Is this a bug with the IDENTITY function.

• Andy Warren

  SSC Guru

  Points: 119902

  More actions

  May 16, 2002 at 5:21 am

  #429248

  I think you're confusing the identity function with the identity property used in table creation.

  Andy

  Andy
  SQLAndy - My Blog!
  Connect with me on LinkedIn
  Follow me on Twitter

• shaley1

  Valued Member

  Points: 64

  More actions

  May 16, 2002 at 5:53 am

  #429251

  No I just found the problem. Its yet another

  “Undocumented feature” aka bug with SQLServer

  7.0 You can't pass a variables to the Identity function seed value.

  http://support.microsoft.com/default.aspx?scid=kb;EN-US;q271827