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
- 17891 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 is table constraint?
Explain the different index configurations a table can have?
State the difference between union and union all?
When would you use a before or after trigger?
How would you use user_constraints table in DB?
What is a constant or literal in ms sql server?
Tell me what is fill factor?
What are the different types of columns types constraints in the sql server?
Explain the difference between clustered and non-clustered index?
Can we call stored procedure in trigger?
What is the maximum size of column in sql server?
What is the contrast between sql and mysql?
Difference between uniqe index and uniqe constraint?
Which trace flags are enabled in sql server?
What are subqueries in sql server?
