Answer Posted / sandeep rana

select max(salary) from salary_table where salary in(select
top 2 salary from salary_table order by salary desc)

List all types of constraints in sql server?

1045

---

How do I perform an unattended install of sql server 2000?

1086

---

How do I repair damaged sql server mdf file database? In previous day my mdf file has got damage due to unknown reasons then I used dbcc chekcdb command but it failed, MDF file is important for me, I don’ know that how to get back mdf file data. Please anyone suggest me?

1751

---

List some of the rules that apply to creating and using a ‘view’

888

---

What is a rownum?

978

---

How can change procedure in sql server?

1067

---

Explain about analysis services?

1051

---

How can I create a report based on a query? : sql server management studio

1016

---

How to delete duplicate rows from table except one?

990

---

What is the difference between getdate and sysdatetime?

1009

---

How to rebuild the master database?

1081

---

What are binary string data types in ms sql server?

1296

---

What does REVERT do in SQL Server 2005?

963

---

Explain syntax for disabling triggers?

1044

---

What is acid mean in sql server?

1120

---