Answer / 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

Answer / veeresh kethari

1.By using case.. set,we can avoid the cursors

2.By using temporary tables/table variables/CTE
with while loop we can avoid cursor in the transaction.

Answer / sunny

update salary set sal=(
case
when sal between 100 and 300 then sal + 1000
when sal between 300 and 500 then sal + 2000
when sal between 500 and 700 then sal + 3000
end)

What is the cpu pressure?

0 Answers  

---

Which operator do you use to return all of the rows from one query except rows are returned in a second query?

0 Answers  

---

How do I change my passwords (database, LDAP, and so on) without causing an outage?

0 Answers   IBM,

---

which is best institute to learn sql server in ameerpet or sr nagar or maithrivanam?please help

3 Answers  

---

Explain the microsoft sql server delete command?

0 Answers  

---

What are the advantages of user defined function?

0 Answers  

---

What is extent? Types of extents?

0 Answers  

---

wat wil hapn if we give the both read and deny read permission to user?

0 Answers   IBM,

---

role of sql sever 2005 in database rather than any other database

0 Answers  

---

How to enter binary string literals in ms sql server?

0 Answers  

---

Can you explain what is the use of custom fields in report?

0 Answers  

---

How do you create a data source?

0 Answers  

---