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   ABC, HCL,

---

What is wide table?

0 Answers  

---

How do I know if localdb is running?

0 Answers  

---

What are the steps you will take, if you are tasked with securing an SQL Server?

1 Answers   HCL,

---

What is the maximum size of a dimension? : sql server analysis services, ssas

0 Answers  

---

Well sometimes sp_reanmedb may not work you know because if some one is using the db it will not accept this command so what do you think you can do in such cases?

2 Answers  

---

What is simple indexing method?

0 Answers  

---

could you please reply for these question: 1.About Use Apply? 2.Avoid cursors - When we have a situation that we can not avoid the use of cursor than what is the alternate solution? is there anything we can use instead of cursor to perform the desired task? which optiomize the peroformance too. 3.What is computed columns? Thanks in advance. Regards, Rupesh

3 Answers  

---

What is a rollup clause?

0 Answers  

---

what are cursors? : Sql server database administration

0 Answers  

---

What is cursor ? And what is difference between Trigger ?

3 Answers   HCL, Polaris,

---

Tell me about Triggers?

3 Answers   Cap Gemini,

---