February 28, 2019 at 12:12 am
Comments posted to this topic are about the item Done testing identity 2
February 28, 2019 at 1:07 am
Good question, thanks Steve.
...
February 28, 2019 at 2:12 am
Yeah, thought 0,0 or 0,1 and assumed it must be the latter.
Oops.
February 28, 2019 at 2:27 am
DBCC CHECKIDENT('dbo.SalesOrderHeader', RESEED, 0)
Checking identity information: current identity value 'NULL'.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
SELECT IDENT_CURRENT('dbo.SalesOrderHeader')
SELECT IDENT_CURRENT('dbo.SalesOrderHeader')
returns 0.February 28, 2019 at 3:45 am
Nice question, thanks Steve...
i liked the wrong options, gives a real twist....
____________________________________________
Space, the final frontier? not any more...
All limits henceforth are self-imposed.
“libera tute vulgaris ex”
February 28, 2019 at 1:04 pm
As documented in a number of places, the explanation "When all rows are removed from the table, the SEED is used for the identity value." is not entirely accurate. DELETE FROM MyTable has different behavior from TRUNCATE TABLE My Table.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply