Any column that is not modified retains its original values, except in certain queries using the CASE expression. See CASE expression for a description of CASE expressions.. To add, drop, or modify a ...

Arthur Fuller explores the value of identity columns and the usefulness of their arbitrary values and discusses ways to use SQL Server 2000's IDENTITY_INSERT setting.