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
- 17663 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
What do you know about system database? : SQL Server Architecture
Explain what is lock escalation?
What is buffer cash and log cache in sql server?
What is the difference between a primary key and a unique key? Are they the same?
How to create an index on an existing table in ms sql server?
What is blocking?
Explain indexes disadvantages?
Explain different types of locks in sql server.
What is sql azure database?
What is @@rowcount in sql?
Do you have any idea about the tcl commands?
What is set nocount on?
How to change the ownership of a schema in ms sql server?
How do I view views in sql server?
What is a join in sql? What are the types of joins?
