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)

Explain iaas, paas and saas?

92

---

Are there any preferred steps that need to be taken care of before starting the installation of sql server 2000?

1030

---

Can you explain how long are locks retained within the repeatable_read and serializable isolation levels, during a read operation with row-level locking?

1038

---

What is the difference between web edition and business edition?

113

---

List out the difference between union and union all in sql server?

1042

---

Explain error and transaction handling in sql server?

1063

---

What is data compression?

1066

---

What is report subscription?

132

---

What is the difference between ddl,dml and dcl commands?

1158

---

Explain about sql server login?

1137

---

What is the latest version of microsoft sql server?

1116

---

What is updatable resultset?

1074

---

What is resource db in sql server?

1058

---

Do you know the cursor optimization tips?

1039

---

What are the types of containers in ssis?

1234

---