Answer Posted / suhail qaiser

or if u want 2nd highest then write this query

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

Name few endpoints exposed by ssrs 2012?

355

---

How display code or Text of Stored Procedure using Sql query in Sql Server ?

1146

---

Explain the difference between control flow and data flow?

997

---

We are updating a field in sql and alter the row also.after giving the commit command the system is crashed.what will happen to the commands given,whether it will update and alter the table or not?

1386

---

How to drop existing indexes in ms sql server?

1072

---

What is report snapshot in ssrs?

269

---

What is sql server agent and what are the two modes of authentication in sql server?

1057

---

What is indexed view?

981

---

Can we deploy SSRS reports on our personal website?

168

---

What are the different Topologies in which Replication can be configured?

1185

---

Differentiate between a local and a global temporary table?

956

---

What is merge join?

1196

---

Are null values the same as that of zero or a blank space?

1040

---

Define Wed Edition in SQL Azure?

100

---

What is use of except clause? How does it differ from not in clause?

1020

---