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 a primary key and a unique key? : Sql server database administration

0 Answers  

---

What are the system database in sql server 2008?

0 Answers  

---

what is a schema in sql server 2005? : Sql server database administration

0 Answers  

---

How much space does sql server 2016 take?

0 Answers  

---

---

Do you know exporting and importing utility?

0 Answers  

---

between cast and convert which function would you prefer and why?

0 Answers  

---

Suppose you want to implement the following relationships while designing tables. How would you do it?a.) One-to-oneb.) One-to-manyc.) Many-to-many

0 Answers  

---

What is simple indexing method?

0 Answers  

---

Explain the dbcc pintable command when would you use it?

0 Answers  

---

 Explain what is sql override for a source taLle in a mapping?

0 Answers   Informatica,

---

What is DCL?

0 Answers  

---