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)

Do you know what are the differences between lost updates and uncommitted dependencies?

1071

---

List the different index configurations possible for a table?

931

---

what are user defined datatypes and when you should go for them? : Sql server database administration

1004

---

How to replace null values in expressions using isnull()?

1095

---

Explain where clause?

983

---

How do you make a trace?

1013

---

Why I am getting this error when dropping a database in ms sql server?

1070

---

How we can refresh the view?

1103

---

What is Dependency Injection and provide example?

1113

---

What is indexing a document?

1030

---

What is the difference between a stored procedure and a user defined function?

1016

---

How can you list all the table constraints in a database?

932

---

How to rebuild the master database?

1074

---

Why truncate is ddl?

1078

---

What is the purpose of update statistics and scope_identity() function?

1090

---