What is Inner Join?

2 Answers  

---

How many primary keys are possible in a table?

0 Answers  

---

How can I tell if sql server is 32 or 64 bit?

0 Answers  

---

How do you use DBCC statements to monitor various aspects of a SQL server installation?

1 Answers  

---

What are triggers? How many triggers you can have on a table? How to invoke a trigger on demand?

0 Answers  

---

What is an index?

8 Answers   Yardi Software,

---

Do you know what are various aggregate functions that are available?

0 Answers  

---

what are the Prerequisites for Replication?

1 Answers   IBM,

---

Differentiate between SQL and ORACLE joins and write their syntax.

0 Answers   Global Logic,

---

What is the difference between in and exists. Ex: select * from emp where empno in(....) and select * from emp where empno exists(....) What is the difference between a Join and Union and Union and UnionAll.

5 Answers   ABC, Accenture,

---

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,

---

How to install sql server 2005 express edition?

0 Answers  

---