Answer Posted / 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 report subscription?

93

---

What are data resources?

508

---

What is the distinction amongst delete and truncate?

587

---

How to modify existing triggers using "alter trigger"?

531

---

What are types of scd? : sql server analysis services, ssas

540

---

---

How can i Relate Tables in SSIS

577

---

What are triggers? How many triggers you can have on a table? How to invoke a trigger on demand?

754

---

What are different types of join?

762

---

Explain different types of Normalization.

601

---

What is the difference between inner join and equi join?

494

---

What happens on checkpoint?

620

---

How to disable triggers using "disable trigger"?

568

---

What are the different types of backups avaialabe in sql server 2005?

630

---

What are the reporting services components?

92

---

What are the main differences between #temp tables and @table variables and which one is preferred?

555

---