Answer Posted / haroon nazir.s

UNION
The UNION command is used to select related information from
two tables, much like the JOIN command. However, when using
the UNION command all selected columns need to be of the
same data type. With UNION, only distinct values are selected.

UNION ALL
The UNION ALL command is equal to the UNION command, except
that UNION ALL selects all values.

The difference between Union and Union all is that Union all
will not eliminate duplicate rows, instead it just pulls all
rows from all tables fitting your query specifics and
combines them into a table.

A UNION statement effectively does a SELECT DISTINCT on the
results set. If you know that all the records returned are
unique from your union, use UNION ALL instead, it gives
faster results.

Example:
Table 1 : First,Second,Third,Fourth,Fifth
Table 2 : First,Second,Fifth,Sixth

Result Set:
UNION: First,Second,Third,Fourth,Fifth,Sixth (This will
remove duplicate values)
UNION ALL:
First,First,Second,Second,Third,Fourth,Fifth,Fifth,Sixth,Sixth
(This will repeat values)

Does table partitioning improve performance?

972

---

What are the difference between data mart and data warehouse? : sql server analysis services, ssas

960

---

What is correlated subquery in sql server?

1073

---

What is logshipping and its purpose?

990

---

How to check status of stored procedure in sql server?

988

---

State the difference between union and union all?

928

---

Tell me about pre-defined functions of sql?

1112

---

How to connect sql server management studio express to sql server 2005 express?

1043

---

Why do we use sql limitations? Which constraints can we use while making a database in sql?

1079

---

Disadvantages of the indexes?

1125

---

What is sql server management studio? : sql server management studio

1076

---

Different types of keys in SQL?

1100

---

Why de-normalization required?

1008

---

Explain what are magic tables in sql server?

998

---

You want to check the syntax of a complicated update sql statement without executing it. What command should you use?

992

---