explicitly identify each table with a specific command. You can insert specific values into a table with an Identity column, but, to do so, you must first set the IDENTITY_INSERT value to ON.

Sometimes, as when testing a table in a Microsoft SQL Server database, you need to reset an identity column to its initial seed value, typically one. During testing, you populate the table with ...