Answer Posted / dewashish kumar pal

Select max(salary) from tablename where salary not in (select max(salary) from tablename);

What is the xml datatype?

630

---

What are cursors and when they are useful?

576

---

What is the difference between inner join and equi join?

492

---

State the difference between union and union all?

523

---

When would you use sql joins?

526

---

---

Can we insert data if clustered index is disabled?

510

---

What is abstracting periodical?

529

---

What is page-level compression?

553

---

How do you Implement SSIS Packages in your Project?

1512

---

When I run the sql server 2000 setup, it just hangs. What do I do?

652

---

What is triggers in ms sql server?

640

---

What do we have to check in database testing?

585

---

How will you find out if there are expensive SQL statements running or not?

582

---

What factors you will consider calculating the storage requirement for that view?

546

---

Does any body please help me what question's have asked for SSRS in the interview?

1668

---