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
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
What is difference between joins and subqueries?
What are the indexes in sql server?
Please explain what is “asynchronous” communication in sql server service broker?
What is the Control Flow in SSIS
How can we determine what objects a user-defined function depends upon?
What is application role in sql server database security? : sql server security
What is data modeling and Reterminal integrity?
What are different types of subquery?
What is a synonym for manipulation?
Explain how you can deploy an SSRS report?
How can delete duplicate records in cte in sql server?
What is surrogate key? : sql server analysis services, ssas
Can we install sql server 2016 on windows 7?
what is a join? : Sql server database administration
How do you migrate data from mssql server to azure?