A DEFAULT Constraint applies only to insert statement

Each colume can have only one DEFAULT constraint

Columns with Identity property or rowversion data type can not have DEFAULT constraint placed on them