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)

What is user-defined function?

983

---

How to populate a table in sql server?

971

---

How do you drop an index?

934

---

How do I find the default sql server instance?

952

---

Describe in brief authentication modes in sql server.

1039

---

What types of replication are supported in sql server?

1071

---

Working with TLogs

1841

---

Where the sql logs gets stored? : sql server database administration

979

---

Why we need sql server?

974

---

What is dml command?

979

---

What is scan table/view and seek table/view when its occurs? : sql server database administration

1063

---

What is the Difference Between Primary and Foreign Key?

1020

---

How to store and query spatial data?

1004

---

What is a database table?

987

---

What is the use of builtinadministrators group in sql server? : sql server security

1058

---