May be this one was the problem:

https://documentation.red-gate.com/pages/viewpage.action?pageId=20185801

I use SQL Compare 10, but I never had this problem before, and I do not keep the scripts...

Sorry I did not see it is for SQL Server 2016 - Administration. If anyone/admin can move it to SQL Server 2008 that will helps.

Thanks for the explanation the...

Thanks Thom. Yes, I won't worry about inserting not unique in deleted table, but we are all have assumption that IDENTITY should be unique increment numbers always 🙂

The...

Thank for your reply. Correct, there is manual reset with:

DBCC CHECKIDENT ('[TestTable]', RESEED, X)

Where X is  the new number, but I did not do it any...

If there are nulls, the first query should give result more than the other 2 queries combine because nulls should not be counted in the 2 queries.

Try use DATEDIFF:

select count(*)...