Answer Posted / kumar

1 My Second Answer.

Select Top 1 * From Tablename where salary in
(select top 2 salary from tablename order by salary desc)
order by salary asc.

Can we insert data if clustered index is disabled?

925

---

What are extended events in sql server?

937

---

Explain how dts is used to extract, transform and consolidate data?

979

---

How can you hide the sql server instances?

1004

---

Does a server store data?

905

---

What is the difference between grant and with grant while giving permissions to the user?

941

---

Explain view in sql server?

1043

---

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

920

---

What is a trigger and its types?

963

---

Your table has a large character field there are queries that use this field in their search clause what should you do?

874

---

what are defaults? : Sql server database administration

1069

---

Explain a differential backup?

995

---

What is sql view?

999

---

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

1038

---

What are advantages of ssrs or why we should use ssrs?

137

---