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 / dinesh sharma
It Simple
Just Write Down The Query
update table_Name set salary=100 where salary is null
| Is This Answer Correct ? | 12 Yes | 28 No |
Post New Answer View All Answers
What do you understand by coalesce in sql server?
Explain microsoft sql server functions?
What do you understand by sql server agent?
How many types of triggers in sql server?
What is function of CUBE ?
Explain the Ways to improve the performance of a sql azure database?
Explain transaction server implicit?
what are statistics, under what circumstances they go out of date, how do you update them? : Sql server database administration
Tell me about builtinadministrator?
What does ss stand for sexually?
Why use cursor in sql server?
What are rest-style architecture's?
What is the process of normalising?
How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database?
What is merge replication?