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 are the steps need to be take improve the speed of a SQLDATA Server?

2 Answers   IBM,

---

I hav 10 records only one column 1,2,3,4,5......10 now am writing query select max(column name) Then What is The Output

9 Answers   Brigade, Wipro,

---

What is database mirroring?

0 Answers  

---

Tell me what is de-normalization and what are some of the examples of it?

0 Answers  

---

what is difference between Enterprise Manager and Query Analyer

6 Answers   CTS,

---

What is 4nf in normalization form?

0 Answers  

---

What is sql collation?

0 Answers  

---

What is the native system stored procedure to execute a command against all databases?

0 Answers  

---

i use few third party softwares. they r all having their own databases . but the data is repeated in all these databases - say a person is in all the three databases, but his name is stoared in diff format in all databases i want to create a centralised database ,and i dont want to re-enter the records . using the exisating records how can i build a centralised database?

1 Answers   Fidelity,

---

How to restart SQL Server in single user mode? How to start SQL Server in minimal configuration mode?

3 Answers  

---

Explain DBCC?

0 Answers   QuestPond,

---

How to select some specific rows from a table in ms sql server?

0 Answers  

---