What is difference between rownum and rowid?

0 Answers  

---

How to provide column names in insert statements in ms sql server?

0 Answers  

---

What is “begin trans”, “commit tran”, “rollback tran” and “savetran”?

0 Answers  

---

Explain unique key in sql server?

0 Answers  

---

Explain the properties of sub-query in sql server?

0 Answers  

---

---

what is the difference between openrowset and openquery?

0 Answers  

---

Can we use Truncate command on a table which is referenced by FOREIGN KEY?

2 Answers   Shriram,

---

What is xdr?

0 Answers  

---

What is acid db?

0 Answers  

---

What is the difference between WHERE AND IN? OR 1. SELECT * FROM EMPLOYEE WHERE EMPID=123 2. SELECT * FROM EMPLOYEE WHERE EMPID IN (123) WHAT IS THE DIFFERENCE?

15 Answers   Adsys, Cap Gemini,

---

What is 3nf normalization?

0 Answers  

---

How to use values from other tables in update statements in ms sql server?

0 Answers  

---