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
- 16840 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
What is autocommit mode in sql server?
Explain what is use of dbcc commands?
How do I schedule a sql server profiler trace?
Explain transaction isolation levels in sql server?
What is the difference between osql and query analyzer?
Write an sql query to find first weekday of the month?
What is a covering index?
What is transact-sql ddl trigger?
Can foreign key be deleted?
What do you do in data exploration
What is an entity-relationship diagram (erd)?
What is sql azure database?
How do you Implement SSIS Packages in your Project?
How do I view views in sql server?
In which tcp/ip port does sql server run? Can it be changed?
