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
- 16035 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 cached report?
What are the events recorded in a transaction log?
How to insert multiple rows with a subquery?
What are statistics?
What is table valued function and scalar valued functions?
What are the results of running this script?
What is the dbcc command and why is it used?
What is a file group?
Explain the properties of subqueries in sql server?
Explain log shipping?
what is sql server? : Sql server database administration
Does an index slow down updates on indexed columns?
What are the options which must be set to allow the usage of optimistic models?
What command is used to create a database in the sql server and how?
How to encrypt data between dialogs?
