Answer Posted / mahima

to avoid cursor use CASE and SET .
to give increment to the employee depending upon the salary

update empsal
set
case when sal between 2000 AND 3000 then sal+1000
when sal between 3000 AND 4000 then sal+2000
end

What causes index fragmentation?

991

---

Why do you need a sql server?

1101

---

What is molap and its advantage? : sql server analysis services, ssas

984

---

Explain the various types of concurrency problem. I.e. Lost or buried updates, uncommitted dependency, inconsistent analysis, phantom read?

942

---

What is the minimum and maximum number of partitions required for a measure group? : sql server analysis services, ssas

1043

---

What do you mean by a dependent functionality in a build?

1145

---

Explain hostprotectionattribute in sql server 2005?

1024

---

What is postgresql server?

997

---

What is factless fact table? : sql server analysis services, ssas

1023

---

Do I need a report server to run reports in my application?

165

---

What is transaction server distributed transaction?

1054

---

What are the different kinds of ssrs reports?

214

---

What is the bookmark lookup and rid lookup?

996

---

How to create an inline table-valued function?

965

---

Will sql server 2005 allow you to reduce the size of a column?

986

---