Answer / soma shaw

A cross join is a Cartesian join. for sets of A and B rows, you'll get a result of A * B rows. A full join will match all possible rows, meaning it will return AT MOST A + B rows.

Give main differences between "Truncate" and "Delete".

0 Answers   HCL,

---

What is the Query of getting last 10 transaction Reports (like insert, update, Delete Data from Tabele) ?

4 Answers   Wipro,

---

What are types of storage modes? : sql server analysis services, ssas

0 Answers  

---

wht's the differece between sqlserver05 and sqlserver2000

3 Answers  

---

What is bulkcopy in sql?

0 Answers  

---

How to apply filtering criteria at group level with the having clause in ms sql server?

0 Answers  

---

What is the advantage of sql server?

0 Answers  

---

What is Schema? and why we use schemas?

4 Answers  

---

What is efficiency data?

0 Answers  

---

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 command is used to rename the database?

0 Answers  

---

1)what is the difference between Reinitializing a Subscription and synchronization the subscription? 2)when to use reinitializing ? 3)when to use synchronization? 4)when adding table or deleting a table what to do?(reinz.. or syn) 5)when adding a column what to do?

0 Answers  

---