What is the difference between row_number and dense_rank?

0 Answers  

---

Define synonym?

0 Answers  

---

What are the new data types are introduced in sql 2000?

0 Answers  

---

what is victor class

0 Answers  

---

i want only duplicates rows from coloumn ex. emp_id(colomn name)1,1,2,3,3,4,5,5. so i want only duplicates no.

3 Answers   iFlex,

---

Which command is used for user defined error messages?

0 Answers  

---

What is the differecne between equi-join and inner-join and natural join..Is there any difference or all are same?

8 Answers   Microsoft,

---

How you can minimize the deadlock situation?

0 Answers  

---

explain how to create a new schema in a database? : Sql server database administration

0 Answers  

---

1)what is the difference between Reinitializing a Subscription and synchronization the subscription? 2)when to use reinitializing ? 3)when to use synchronization? 4)when adding table or deleting a table what to do?(reinz.. or syn) 5)when adding a column what to do?

0 Answers  

---

Mention the different types of replication in sql server.

0 Answers  

---

What is deadlock and how to avoid the deadlocks.

3 Answers   TCS, Wipro,

---