Answer Posted / sanjeev aggarwal

If there are two salaries are same in a single table then
what we do??
example:-

id salary
s1 1200
s2 1500
s3 1200
s4 1500
s5 1800

now what query we used??

What is the difference between row_number and dense_rank?

829

---

List the advantages of using stored procedures?

999

---

What is store procedure? How do they work?

958

---

What is the difference between grant and with grant while giving permissions to the user?

902

---

What is user-defined functions? What are the types of user-defined functions that can be created?

981

---

Why does a sql statement work correctly outside of a user-defined function, but incorrectly inside it?

824

---

How to Improve the performencs of SQL Server 2005 exclude stored Procedure and Indexes?

1965

---

Explain transaction isolation levels in sql server?

1039

---

Explain about analysis services?

987

---

What are the differences between substr and charindex in sql server.

1017

---

As per your opinion what are the five top responsibilities of a dba? : sql server database administration

1064

---

How to create a simple stored procedure in ms sql server?

980

---

What are different replication agents and what's their purpose? : sql server replication

960

---

What does the on update no action do?

965

---

Do you know what is raid and what are different types of raid configurations? : SQL Server Architecture

998

---