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)

Equi join and non equi join is possible with sql server?

0 Answers  

---

What do you understand by physical_only option in dbcc checkdb?

0 Answers  

---

What is 3nf normalization form?

0 Answers  

---

Can we insert data if clustered index is disabled?

0 Answers  

---

What is usually the first word in a sql query?

0 Answers  

---

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

2 Answers  

---

How would you Update the rows which are divisible by 10, given a set of numbers in column?

3 Answers  

---

Explain the categories of stored procedure i.e. System stored procedure, local stored procedure, temporary stored procedure, extended stored procedure, remote stored procedure?

0 Answers  

---

what are the new features introduced in sql server 2000? : Sql server database administration

0 Answers  

---

What is shrink log file?

0 Answers  

---

How to select Distinct columns from the table, table having 20 columns and i want all coulmns

5 Answers   Wipro,

---

What are functions

3 Answers  

---