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 a live lock? : Sql server database administration

964

---

in the physical file layout, where should the transaction log be stored in relation to the data file? : Sql server administration

1074

---

Is oracle faster than sql server?

958

---

How to create stored procedures with parameters in ms sql server?

1089

---

How do you Implement SSIS Packages in your Project?

1936

---

What is the purpose of optimization?

1005

---

Is ssrs support other database except ms sql server?

142

---

Why is the need for data conversion transformations?

1073

---

What is the difference between for auto and for nested?

1013

---

How do I edit a procedure in sql server?

965

---

What are the different types of cursor?

1100

---

What is the maximum size of sql server database?

1017

---

Can sql servers link to other servers?

1095

---

Explain various data region available in ssrs with their use?

943

---

What is identity?

1025

---