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
- 17925 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 are clustered and non-clustered index?
what is create database syntax? : Sql server database administration
what is the difference between a primary key and a unique key? : Sql server database administration
What is attribute relationships, why we need it? : sql server analysis services, ssas
How to download and install sql server 2005 books online?
Do you know what is fill factor and pad index?
What do you mean by a dependent functionality in a build?
How to modify existing triggers using "alter trigger"?
How to verify the port number of the sql server?
How to drop an existing stored procedure in ms sql server?
Do you know what is sql service broker?
What is schemabinding a view?
Explain different types of BACKUPs avaialabe in SQL Server? Given a particular scenario, how would you go about choosing a backup plan?
What is the difference between varchar and varchar(max) datatypes?
What is the use of @@spid?
