Answer Posted / vidit

DECLARE @SQL VARCHAR(2000), @N INT
SET @N = 5
SET @N = @N - 1

SET @sql = 'select top 1 salary from ABC where salary not
in ( SELECT TOP ' + CAST(@n AS VARCHAR(100)) + ' salary
FROM ABC order by salary desc ) ' + ' order by salary desc '

SELECT @SQL
EXEC @SQL

What authentication modes does sql server support?

1103

---

What do you understand by mirroring and mention the advantages of the mirroring?

1068

---

What are the system database in sql server 2005?

1045

---

Hi, I Created 3 Tables Person(PersID[prkey],Name,Email,Password), Project(ProjName,ProjID[prkey],ProjLeader,ProjManager) & ProjectInvolvement(EntryDate,ProjID[frkey],PersID[frkey],ProjDuration). For this how can i INSERT,UPDATE & DELETE Through PROCEDURE? Please Post the Answer for me. Desai.

1849

---

optimization techinques

2680

---

When a primary key constraint is included in a table, what other constraints does this imply?

989

---

What are the security related catalog views? : sql server security

950

---

What is SQL Azure Federations?

112

---

what are isolation levels? : Sql server database administration

995

---

What are different types of statements that are supported by sql?

1047

---

Explain external key management in sql server 2008

890

---

How to connect php with different port numbers?

1087

---

Please illustrate physical database architecture? : SQL Server Architecture

988

---

What is plan freezing?

971

---

What are the 10 characteristics of data quality?

956

---