binding

[StateSQLboy]

I have created a default value and have bound it to the column. But, it won't put that value into the column when there is a null value.
Here is the select statment I am using for this problem

Select ' ',Count(Sites)


Can Any one tell me why this won't be working, and how should I have the table designed? Right now both columns are set to allow Null values. Is this appropriate?

 

[ClaireHCM]

Actually default works specially when you dont assign it any value ,like this (say you have a table with 2 columns ,col1 with default,col2 not with default)

insert into mytable(col2) Select Count(Sites)

So only when you want to assign col1 value you query like this

insert into mytable select 'Hello',count(sites)