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
- 17846 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 action plan is preferred if sql server is not responding?
Explain external key management in sql server 2008
What program is used to store the data source file?
What is the difference between left and right outer join?
Explain syntax for dropping triggers?
Explain indexing and what are the advantages of it?
What is difference between sql and sql server?
What is the default port for SQL Server over a firewall?
How to implement service broker?
What are the different types of collation sensitivity?
Find columns used in stored procedure?
How does index makes search faster?
Write a query for primary key constraint with identity key word?
Can the “if update (colname)” statement be used in a delete trigger?
What is self join in sql server joins?
