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,

---

How does using a separate hard drive for several database objects improves performance right away?

0 Answers  

---

How to get a list of columns in a view using "sys.columns" in ms sql server?

0 Answers  

---

check, not null,unique

2 Answers   IBM,

---

What's the difference between a primary key and a unique key?

4 Answers  

---

Explain the truncate command?

0 Answers  

---

Is it possible to import data directly from t-sql commands without using sql server integration services? If so, what are the commands?

0 Answers  

---

Explain about the command-line tool SQLCMD?

0 Answers  

---

Do you know how to send email from database?

0 Answers  

---

How to stop log file growing too big?

0 Answers  

---

where the connection string store in the database

0 Answers   HCL, Wipro,

---

Describe in brief databases and sql server databases architecture.

0 Answers  

---