Unanswered: reset identity value on a table variable
Is anyone familiar with a way to reset the identity value on a table variable...
the DBCC command doesnt seem to work on a table variable...
I try this:
dbcc checkident ('@block, RESEED, 1)
I get this msg, rightfully so..
Could not find a table or object named '@block'. Check sysobjects.
My block table has an identity column called "blockid". Is there anyway I can update this column after the inserts have been done? Or does anyone know of any other way I can use the identity capability on a table variable?