set default value 0 to column in sql server select code example

Example: set default column value sql

Name Varchar(255) default "Fred"