Please get the 4 th maximum salary from a table without using any sql keyword (TOP,MAX are mot allowed)

8 Answers  

---

Define clusters?

0 Answers  

---

How to throw custom exception in Stored Procedure?

0 Answers   MCN Solutions,

---

What is the purpose of object explorer and its features? : sql server management studio

0 Answers  

---

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

0 Answers  

---

What is an extended stored procedure? Can you instantiate a COM object by using T-SQL?

1 Answers  

---

I have a huge amount of data which is displayed in a report. The data is viewed every day. Every day the data is displayed in 30 secs but suddenly today it is giving an timeout message today. Data has not been changed. The situation is same as yesterday. What might be the reason??? Please Answer.

4 Answers   Satyam,

---

How to rename an existing table with the "sp_rename" stored procedure in ms sql server?

0 Answers  

---

Is candidate a key?

0 Answers  

---

1. What are the grouping function in SQL ? 2. If base table of a view deleted means, what will happen while we querying on view ? will give any error ? 3. Difference between DROP, DELETE, TRUNCATE table ? 4. What is constraints and types ? 5. What is max size of nchar & nvarchar ? 6. Define ROLLBACK, COMMIT, SAVE POINT 7. How non-clustered better ? or rank the Clustered, Non-Clustered and Table scan in performance wise 8. Select 10 rows from a table ? 9. Define DML, DDL, DCL, DTL commands ? 10. What is mean by NULL value ? NULL means "" or 0 or undefined ? 11. Default constraints ? 12. Can we have more then primary Key in table ? 13. Type of integrity ? Entity, Referential, Domain ?

10 Answers   Perot Systems,

---

What do you understand by hotfixes and patches in sql server?

0 Answers  

---

How can you find out which stored procedures are recompiling?

0 Answers  

---