Answer Posted / sandeep rana

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

What is a transact-sql statement batch in ms sql server?

507

---

List few advantages of stored procedure.

538

---

What are the acid properties?

553

---

How adventureworkslt tables are related?

531

---

What are the mathematical functions supported by sql server 2005?

549

---

---

How do I delete a sql server database?

549

---

What is cursor in ms sql server?

564

---

How can sql server instances be hidden? : sql server security

599

---

What are database states in ms sql server?

653

---

What are page splits?

581

---

Can binary strings be converted into numeric or float data types?

555

---

What is ssl in sql server?

550

---

How do I view a stored procedure in sql server query?

539

---

Define Wed Edition in SQL Azure?

80

---

What are commit and rollback in sql?

567

---