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 use of for clause?

0 Answers  

---

You want to check the syntax of a complicated update sql statement without executing it. What command should you use?

0 Answers  

---

What is self contained multi valued query?

0 Answers  

---

How to how to convert numeric expression data types using the convert() function??

0 Answers  

---

difference between truncate, delete aur drop?

2 Answers  

---

What is resource governor?

0 Answers  

---

What is the purpose of the tempdb database?

0 Answers  

---

if 3 duplicate records in a table,i want to delete 2 duplicate records by keeping 1 duplicate and 1 original as it is,how?

5 Answers  

---

Explain different types of Normalization.

1 Answers   HPCL, Hughes Systique Corporation, Ittiam Systems,

---

How to delete existing rows in a table?

0 Answers  

---

What authentication modes does sql server support?

0 Answers  

---

What stored by the model?

0 Answers  

---