Difference between rowid and rownum in SQL?

1 Answers   Virtusa,

---

What's the difference between a primary key and a unique key?

10 Answers   Wipro,

---

What all db objects can be found in MSDB database of a SQL Server instance?

2 Answers   Accenture,

---

Explain about nested stored procedure?

0 Answers  

---

What are the new features in SQL Server 2005 when compared to SQL Server 2000?

0 Answers  

---

---

Why use “in” clause in sql server?

0 Answers  

---

What is lock escalation and what is its purpose?

0 Answers  

---

What is reference section?

0 Answers  

---

What stored by the model?

0 Answers  

---

What is the difference between two queries: 1. SELECT * FROM table WHERE 1=1; 2. SELECT * FROM table

17 Answers   HP,

---

What is transaction server consistency?

0 Answers  

---

if 3 duplicate records in table,i want to delete 2 alternating duplicate records by keeping 1 duplicate and 1 original as it is,how?

2 Answers  

---