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 temporary table in sql server? Why we use temp table?

0 Answers  

---

What is the syntax for encrypting a column in SQL Server?

0 Answers   MindCracker,

---

What is a natural primary key?

0 Answers  

---

What is row_number () and partition by in sql server?

0 Answers  

---

What is application role in sql server database security? : sql server security

0 Answers  

---

What do you understand by mirroring and mention the advantages of the mirroring?

0 Answers  

---

How many types of subqueries are there in sql server?

0 Answers  

---

How will you fine tune a stored procedure or what are the steps that should be taken to fine tune or optimize a stored procedure?

1 Answers   Logitech, Mphasis,

---

In clustered and non clustered indexes which one is faster while executing a query ?

1 Answers  

---

How do I port a number to sql server?

0 Answers  

---

What are the steps you will take, if you are tasked with securing an SQL Server?

1 Answers   HCL,

---

do you know how to configure db2 side of the application? : Sql server database administration

0 Answers  

---