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
- 17895 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
Which language is supported by sql server?
Does a full backup include transaction log?
What do you understand by triggers and mention the different types of it?
How do you create an execution plan?
What are temporal tables in sql server 2016?
What do you mean by the term 'normalization'?
What is a natural primary key?
What is an etl file?
How will you monitor replication latency in transactional replication? : sql server replication
Tell me about pre-defined functions of sql?
How you can change a cross join into an inner join?
How to modify an existing stored procedure in ms sql server?
Mention the differences between sql server and mysql.
What will be the value of @@fetch_status if a row that was a part of the cursor resultset has been deleted from the database after the time the stored procedure that opened the cursor was executed?
How to identify current user in ssrs report?
