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 partition, how will you implement it? : sql server analysis services, ssas

0 Answers  

---

Hi, I Created 3 Tables Person(PersID[prkey],Name,Email,Password), Project(ProjName,ProjID[prkey],ProjLeader,ProjManager) & ProjectInvolvement(EntryDate,ProjID[frkey],PersID[frkey],ProjDuration). For this how can i INSERT,UPDATE & DELETE Through PROCEDURE? Please Post the Answer for me. Desai.

0 Answers  

---

Is the order of columns in the set clause important in ms sql server?

0 Answers  

---

What is the simplest way to create a new database in ms sql server?

0 Answers  

---

Please explain go command in sql server?

0 Answers  

---

create procedure proc1 (@a int) as begin if @a=1 create table #temp(a1 int) else create table #temp(a1 int) end while executeing the above code it shows error like '#temp already exist' .why it shows an error?

8 Answers   IBM,

---

Differences between logshipping and mirroring

1 Answers   Microsoft, Syntel,

---

If a stored procedure is taking a table data type, how it looks?

1 Answers  

---

what are the new features introduced in sql server 2000? : Sql server database administration

0 Answers  

---

Explain timestamp datatype?

0 Answers  

---

What are the options which must be set to allow the usage of optimistic models?

0 Answers  

---