how to change nullable column to not null with default 0 in sql server

right click table name -> Modify

now select column from list, uncheck 'Allow Nulls'

for set default value,
see, column properties there is Default value or Binding property set it to 0
Save...

now, when ever user pass null in insert query it will take it's value 0

Note : for records already exist in table will not be affect (will not apply automatically 0 instead of null)
so, if you want this in existing records then fire update query

e.g.

SQL

update tbl1 set col1=0 where col1=Null

Happy Coding!
:)

In SQL Server, a column's default value can be specified as part of the Create Table statement. This default value will be set for the specified column in cases where an insert is performed but this column's value is not set. The given example sets this default as 'MyDefaultValue' for name column.

Example:


Create Table MyTable
(id int not null,
name char(50) default 'MyDefaultValue')