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
- 17738 Views
- ABC, HCL, I also Faced
- E-Mail Answers
Answer Posted / justus
update tablename set salary=100 where salary is null
| Is This Answer Correct ? | 6 Yes | 10 No |
Post New Answer View All Answers
Explain candidate key, alternate key, and composite key?
What is replace and stuff function in sql server?
What is full outer join in sql server joins?
What are the essential components of sql server service broker?
Why normalization is used?
How to get a list of columns in a view using the "sp_help" stored procedure?
What is shared lock?
What is the difference between a "where" clause and a "having" clause?
Can a table have 2 foreign keys?
What are the advantages to use stored procedures?
What happens if the update subquery returns no rows in ms sql server?
How to execute stored procedure and set temp table in sql server?
What is open database communication (odbc)?
What is normalization and its types?
What are sp_configure commands and set commands?
