Deleting the table doesn't reset the seed although i imagine using go should drop the table and variable to reset the seed. @maxlimit in the query above was to get the top 900 of the query and since the table variable would have a different starting identity key, this would solve that issue.. Hello. i am looping over a parent table in order to generate a sequential number, starting with 1, for each row in its child table. i'm using a table variable with an identity column to generate the sequential number, as shown below.. In memory-optimized tables the seed and increment must be set to 1,1. setting the seed or increment to a value other than 1 results in the following error: the use of seed and increment values other than 1 is not supported with memory optimized tables. examples a. using the identity property with create table. the following example creates a.
Why don't you just alter the table and set allocationid as an identity field? you wouldn't have to fuss with variables, then. identity sill not take value for a seed form variable. as i. Figure b shows the result of using create table to create a table named orders and setting the orderid column's identity seed and increment values to 100 and 10, respectively. as you can see, the. 2. create an empty table using create table and then use dbcc checkident (this accepts variable for seed parameter) to reseed the table before doing the insert. this will be fine if you are dumping small number of rows into the temporary table & performance is not the main criteria..
