Answer Posted / santosh kumar

select Top 1 salary from ( select top 2 salary from
emp_table order by salary desc)temptable order by salary
desc.

Why truncate is ddl?

1133

---

Explain what is analysis service repository?

1047

---

What is tablesample?

1175

---

List out different types of normalizations in sql server and explain each of them?

971

---

What is the datatype of rowid?

963

---

Explain the commands in sql server?

1095

---

What is precedence constraint?

1035

---

We need to perform what steps in the following order to work with a cursor?

1273

---

Explain various data region available in ssrs with their use?

983

---

What is the difference between index seek vs. Index scan?

1062

---

What are trace flags and mention a few common trace flags used with sql server?

1135

---

Will the writetext statement activate a trigger?

1153

---

Do you know the policy based administration feature of sql server 2008?

999

---

What is ms sql server service broker?

1040

---

Do you know sql server 2008 introduces automatic auditing?

1048

---