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 ...

I've got this view defined on two tables, one of which has an identity field that auto increments. There seems to be no way to insert into this view. If I leave the auto-increment field blank it ...