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
- 16839 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
Explain forward - only cursors?
Can you explain powershell included in sql server 2008?
What are the advantages of using stored procedures?
What are the disadvantages of using querystrings to send data from one page to another?
What keyword you will use to get schema appended to the result set of a ‘for xml’ query?
List some advantages and disadvantages of stored procedure?
What are tables in sql server?
Explain the disadvantages of cursors?
What is database white box testing?
Which tcl commands are available on the sql server?
what is a major difference between sql server 6.5 and 7.0 platform wise? : Sql server database administration
What is clustered index
Who developed sql server?
Why functions are used in sql server?
Explain what are the different index configurations a table can have?
