---- Из BOL ----

There are two ways to apply defaults:

Create a default definition using the DEFAULT keyword in CREATE TABLE to assign
a constant expression as a default on a column. This is the preferred, standard
method. It is also the more concise way to specify a default.

Create a default object using the CREATE DEFAULT statement and bind it to columns
using the sp_bindefault system stored procedure. This is a backward compatibility
feature.