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 are the types of normalization?

0 Answers  

---

If suppose in a table ship(name,year),find ship name having first and last name(i.e having space in between) ex: SAINT LOUIS,JET LAKE.

4 Answers  

---

Where do you think the users names and passwords will be stored in sql server?

4 Answers   BirlaSoft,

---

What is Dedicated Administrator Connection in sql server 2005?

2 Answers  

---

---

please give me query code of unique fuction select UNIQUE (name) from emp_info Incorrect syntax near the keyword 'UNIQUE'.

1 Answers   TCS,

---

How to use union to merge outputs from two queries together in ms sql server?

0 Answers  

---

What is the most common trace flags used with sql server?

0 Answers  

---

How to replace given values with null using nullif()?

0 Answers  

---

As a general practice, it is recommended to have dbo be the owner of all database objects however, in your database you find number of tables owned by a user other than dbo, how could you fix this?

0 Answers  

---

What happens if the update subquery returns multiple rows in ms sql server?

0 Answers  

---

What are the indexes in sql server?

0 Answers  

---