Multi-part keys may change behavior. SQL Server does not allow nulls in any part of a multi-part key. If you have records ...