Explain optimistic and pessimistic concurrency?

0 Answers  

---

What is the boxing and unboxing concept in .net?

0 Answers  

---

What happens when transaction log is full?

0 Answers  

---

How we can refresh the view?

0 Answers  

---

select the 3rd maximum salary from sql server database if 4 (just an example In practically I may not know the exact situation) of the highest salaries are equal.

8 Answers   TCS,

---

---

How many types of the database links?

0 Answers   MCN Solutions,

---

What are the differences between stored procedure and the dynamic sql?

0 Answers  

---

What is row_number () and partition by in sql server?

0 Answers  

---

Why is sql server log file full?

0 Answers  

---

What is sub-query in sql server?

0 Answers  

---

How to locate and take substrings with charindex() and substring() functions?

0 Answers  

---

How to check table values in sql server?

0 Answers  

---