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
- 16049 Views
- ABC, HCL, I also Faced
- E-Mail Answers
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 a stored procedure?
What is sql collation?
Does order by actually change the order of the data in the tables or does it just change the output?
What will be the maximum number of index per table?
What is right outer join in sql server joins?
What is the difference between ‘having’ clause and a ‘where’ clause?
What is the difference between count and distinct count?
When I run the sql server 2000 setup, it just hangs. What do I do?
How to handle error or exception in sql?
How is a full-text index updated?
do views contain data ?
What are the different subsets of sql?
How many columns can we include on clustered index ?
What is a collation?
Can binary strings be converted into numeric or float data types?
