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,

---

Can we use Truncate command on a table which is referenced by FOREIGN KEY?

2 Answers   Shriram,

---

you notice that the transaction log on one of your databases is over 4gb the size of the data file is 2mb what could cause this situation, and how can you fix it? : Sql server administration

0 Answers  

---

How to use wildcard characters in like operations in ms sql server?

0 Answers  

---

Create a dts package to produce a text file using the ‘update statistics’ command for the tables in a database with obsolete statistics.

0 Answers  

---

how to write test cases for testing databases,especially for testing and writing test cases for stored procedures.any real time database testers.please answer me.

0 Answers  

---

Does the order of columns in update statements matter?

0 Answers  

---

how do you implement one-to-one, one-to-many and many-to-many relationships while designing tables? : Sql server database administration

0 Answers  

---

What is the template in sql?

0 Answers  

---

What is sql injection and why is it a problem? : sql server security

0 Answers  

---

What is BCP? When do we use it?

2 Answers  

---

can you instantiate a com object by using t-sql? : Sql server database administration

0 Answers  

---