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

SQL Server Drill Down explores all aspects of Microsoft SQL Server and related applications, with a particular emphasis on issues of interest to SQL Server data professionals. Key areas of focus ...

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.