Answer Posted / arun

SELECT MAX(salary)FROM employee WHERE salary NOT IN
(SELECT TOP 1 salary FROM employee ORDER BY salary DESC)

How to disconnect from a sql server using mssql_close()?

685

---

What is a trigger in sql server?

632

---

Can two tables share a primary key?

598

---

What is database black box testing?

690

---

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

656

---

---

What is a full text index?

572

---

Mention a few common trace flags used with sql server?

615

---

What are scalar functions in sql?

710

---

what are the different types of SSRS reports?

116

---

can you instantiate a com object by using t-sql? : Sql server database administration

612

---

Do you know spatial data types - geometry and geography in sql server 2008?

679

---

How can you know if the row fetched from cursor is still valid in underlying table?

622

---

Explain what is meant by replication of database?

620

---

Can you explain different types of joins?

633

---

What is meant by dirty read?

637

---