without using query means why you goto Sql Server just copy all the values into Excel then replace the null
value into your value after replace copy the value paste into the table.other wise refer the Karthik
answer when you create a table at the time set the default value into that column means when ever pass the empty value into that column means automatically store the default value in that column.
Insert condition do not pass the empty value into the column.
For example.... Table have Id,Name,City, in this table we set default value ('Chennai') into city column means
insert into table (Id,Name,City) values (1,'Ram','Mumbai')
with out value..
.insert into table (Id,Name) values (2,'Sam') // Now automatically set Chennai value.
if we pass the empty value...
insert into table (Id,Name,City) values (3,'Raj','') //Now store empty value in city column
If you already have the value in table means use update query..
update table set value =1 where value is null
its the simple way...
Naeem2049, if this helps please login to Mark As Answer. | Alert Moderator