1.what are diff types of joins , and explain diff between cross join and full outer join 2.diff types of views 3. Diff types of index 4. What is diff b/w stores procedure and function procedure 5.diff between double and int in SQL 6.diff between char and varchar in SQL. 7.Oracle or SQL whice you will preferred and why.

0 Answers   Aptroid,

---

Who developed sql server?

0 Answers  

---

What is the difference between seek predicate and predicate?

0 Answers  

---

What is a trigger?

7 Answers  

---

Mention the differences between local and global temporary tables.

0 Answers  

---

---

what is the out put of below queries? a. select * from Emp where null = null; b. select * from Emp where 1=1;

13 Answers   Patni,

---

What are the authentication modes in SQL Server?

4 Answers   IBM, iSmart,

---

What are alternate keys?

0 Answers  

---

Does sql server 2000 full-text search support clustering?

0 Answers  

---

can a database be shrunk with users active? : Sql server administration

0 Answers  

---

Explain different types of self contained sub query?

0 Answers  

---

Can a stored procedure call another stored procedure. If yes what level and can it be controlled?

2 Answers  

---