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

How to download and install microsoft .net framework version 2.0?

1101

---

hi i am working as a testengineer , so i want to no the backend data base connection can any one tell mwe in detail

2154

---

Can coalesce return null?

945

---

What is the difference between for xml raw and for xml auto?

973

---

What is the purpose of floor function?

974

---

how do you determine the Load performance of any query in sql server {example how do u determine performance of a select stmnt which returns Dynamically many no of records ... some times 100,1000,10000 etc., }

2261

---

What happens to a statement batch if there is a compilation error?

897

---

What is proper subset of candidate key?

944

---

Define inner join in sql server joins?

986

---

What is dbcc updateusage?

1150

---

How to list all triggers in the database with sys.triggers in ms sql server?

1011

---

What is postgresql server?

938

---

What is a functions and types in sql server?

1010

---

How do indexes help, types?

908

---

What's new in sql management studio for sql server? : sql server management studio

992

---