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 sql case statement used for? Explain with an example?

0 Answers  

---

my problem is tempdb tempdb(dbname) 77752.95 MB(db size) 25345.03 MB (unallocated size) suppose i increased temp db size 10 gb . after increase the temp db showing 87 gb (dbsize) 25346.03MB(unallocated size)--unallocated size is showing same .please clarify.

1 Answers  

---

How to start and end transact-sql statements?

0 Answers  

---

What are key, name and value columns of an attribute? : sql server analysis services, ssas

0 Answers  

---

---

What is explicit cursors?

0 Answers  

---

Do you know what is normalization of database? What are its benefits?

0 Answers  

---

What are the different types of columns types constraints in the sql server?

0 Answers  

---

What are the joins in sql server? : sql server database administration

0 Answers  

---

Explain DBCC?

0 Answers   QuestPond,

---

What are the differences between having and where clause.

0 Answers  

---

If you're given a raw data table, how would perform etl (extract, transform, load) with sql to obtain the data in a desired format?

0 Answers   Facebook,

---