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
- 17859 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
Who developed sql server?
What is the difference between migration and upgradation in sql server?
Explain Capacity planning to create a database? and how to monitor it?
Tell me about normalization in DBMS.
Define normalisation?
my name is sejal I have cleared the sbi clerk exam. I am BCA graduate My favorite subject RDBMS Relational database management system. so please send me rRDBMS related interview questions
How to declare a cursor with "declare ... Cursor" in ms sql server?
What is mean by candidate key?
What are the steps you will take to improve the performance of a poor performing query?
What are different types of data sources?
What is database black box testing?
Do you know what is user defined datatypes and when you should go for them?
explain what is raid and what are different types of raid configurations? : Sql server database administration
How to define and use table alias names in ms sql server?
How to delete all rows with truncate table statement in ms sql server?
