Explain “row_number()” in sql server with an example?

0 Answers  

---

Advantages and disadvantages of stored procedures.

2 Answers   HCL,

---

What is the difference between join and inner join?

0 Answers  

---

How to Generate a Series of Random Integers With T-SQL?

1 Answers  

---

can any one please send sql quries most used in applications.

2 Answers  

---

---

What is the difference between update lock and exclusive lock?

0 Answers  

---

Is it true that rules do not apply to data already existing in a database at the time the rule is created?

0 Answers  

---

How can a database be repaired?

0 Answers  

---

What do you mean by a Composite primary key?

0 Answers   Genpact,

---

How do I find the transaction log size in sql server?

0 Answers  

---

Difference between Cluster and Non-cluster index?

32 Answers   Accenture, Agility e-Services, eClinicalWorks, HCL, Infosys, Oracle, Satyam, Yardi,

---

How to find the service pack installed? : sql server database administration

0 Answers  

---