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
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 merge?
what is a join and explain different types of joins? : Sql server database administration
What is the purpose of the tempdb database?
What is the difference between mysql and sql server?
How to update multiple rows with one update statement in ms sql server?
Explain a checkpoint?
What is a mutating table error and how can you get around it?
what is the difference between writing data to mirrored drives versus raid5 drives. : Sql server administration
What is report snapshot?
How real and float literal values are rounded?
How to send email from database?
How do you run a trace?
What is exporting utility?
What is the difference between the application object and session object?
John exports information periodically from a microsoft sql server database to an oracle database what is the best way to do this?