It Simple Just Write Down The Query update table

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 / dinesh sharma

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

Please Help Members By Posting Answers For Below Questions

What do you understand by the analysis services in sql server?

889

Explain tables in SQL Azure?

120

Name some of the open source software that you can use in alternative to SSR?

151

Explain what stored procedure sp_replcounters is used for? : sql server replication

1452

How to provide default values to stored procedure parameters?

1002

Can two tables share a primary key?

947

What are scalar functions?

946

What authentication modes does sql server support?

1015

What is meant by indexing files?

984

what happens on checkpoint? : Sql server database administration

1017

When to use null data driven subscription?

196

What happens when transaction log is full?

868

What are subqueries in sql server? Explain its properties.

964

Can we store videos inside the sql server table?

907

What is a view and what are its advantages?

1052