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 do you mean by an execution plan?

0 Answers  

---

Define clusters?

0 Answers  

---

What is the difference between temp table and table variable?

8 Answers   Microsoft,

---

Can you explain important index characteristics?

0 Answers  

---

What is an etl file?

0 Answers  

---

How to convert character strings into numeric values?

0 Answers  

---

Explain log shipping and mention its advantages.

0 Answers  

---

Does view occupy space?

0 Answers  

---

Can you leave a union at any time?

0 Answers  

---

Hello all, I have data like :- year amt 2004 10 2005 20 2006 30 Now i want output as:- 2004 2005 2006 10 30 60 but i have to use here group by on year.So, i need a single query within that i can find.

3 Answers  

---

What are the differences between triggers and stored procedures?

0 Answers  

---

How many levels of sp nesting are possible?

0 Answers  

---