Answer Posted / vijay

select top 1 sal
from
(select top 3 sal
from emp
order by sal desc )sub
order by sal

Explain the third normal form(3nf)?

523

---

List the advantages of using stored procedures?

563

---

How to enter date and time literals in ms sql server?

510

---

What is the default order of an order by clause?

584

---

What are recommended options to be used while using db mirroring? : sql server database administration

573

---

---

Where are sql server usernames and passwords stored in the sql server?

613

---

How to insert new line characters into strings?

562

---

What is nonclustered index on computed columns?

573

---

What is trace flag in sql server?

525

---

can we have a nested transaction? : Sql server database administration

505

---

What is the contrast between sql and mysql?

593

---

How do you send email on SQL Server?

584

---

What are the differences between stored procedure and view in sql server?

625

---

What triggers long term care?

562

---

Explain transaction server consistency?

526

---