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)

How many types of the database links?

0 Answers   MCN Solutions,

---

What the class forname () does?

0 Answers  

---

what is Archive old data?

1 Answers  

---

What are Row versions of DataRow?

0 Answers  

---

What are triggers in ms sql server?

0 Answers  

---

Why is sql server log file full?

0 Answers  

---

How to retrieve data from log files in SQL SERVER ?????

1 Answers  

---

Which are the important points to note when multilanguage data is stored in a table?

0 Answers  

---

How do I save a stored procedure in sql server?

0 Answers  

---

Do you know how to make remote connection in database?

0 Answers  

---

what is the disadvantage of SQL Loder?

1 Answers   TCS,

---

table:employee EID ENAME MID(manager ids) 101 rama null 102 sita 101 103 siva 101 104 ganesh 103 . . . . . . for 103 ID the manager ID is 101(RAMA) and for 104 manager is SIVA if i give employee id (EID) you have to tell the manager for that EID write query? eample:if i give 102 .The query output should be manager for 102 ID that it should print RAMA as output

7 Answers  

---