May 16, 2002 at 5:14 am
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.
May 16, 2002 at 5:21 am
I think you're confusing the identity function with the identity property used in table creation.
Andy
May 16, 2002 at 5:53 am
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
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply