update tablename set salary=100 where salary is null

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

Question Posted / justus

6 Answers
18079 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

Please Help Members By Posting Answers For Below Questions

What is difference between joins and subqueries?

1169

What are the indexes in sql server?

1183

Please explain what is “asynchronous” communication in sql server service broker?

979

What is the Control Flow in SSIS

1144

How can we determine what objects a user-defined function depends upon?

1067

What is application role in sql server database security? : sql server security

1119

What is data modeling and Reterminal integrity?

2008

What are different types of subquery?

1302

What is a synonym for manipulation?

1045

Explain how you can deploy an SSRS report?

156

How can delete duplicate records in cte in sql server?

1012

What is surrogate key? : sql server analysis services, ssas

1159

Can we install sql server 2016 on windows 7?

1191

what is a join? : Sql server database administration

1323

How do you migrate data from mssql server to azure?

167