Interested to Buy Any Domain ? << Click Here >> for more details...
how to update a null value field in sql server
eg
a table contains 3 fields id,name,salary
and 3 records
salary of 1 record is null
i want update the nullfield
111 arun 300
112 ddd 200
113 ttt null
i want to update table with add 100 to every record include null
after updation
the recrds should be
111 arun 400
112 ddd 300
113 ttt 100
- 6 Answers
- 17672 Views
- ABC, HCL, I also Faced
- E-Mail Answers
Answer Posted / ganapathi
solution 1:
update table_name set
salary = isnull(salary,0) + 100
solution 2:
update table_name set
salary = case when
salary is null then 100
else salary + 100
end
| Is This Answer Correct ? | 49 Yes | 1 No |
Post New Answer View All Answers
Explain the concept of view and Types of views in SQL server?
What is the difference between locking and multi-versioning?
Does sql server 2000 full-text search support clustering?
What are synonyms?
What is stored procedures?
What does Master database contains?
how you can move data or databases between servers and databases in sql server? : Sql server administration
How to concatenate two character strings together?
What are sql servers used for?
How to stop log file growing too big?
How to create user defined functions with parameters?
Is it true, that there is no difference between a rule and a check constraint?
What are constraints in microsoft sql server?
Is mysql the same as sql server?
How to round a numeric value to a specific precision?
