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 are different backups available in sql server?

998

---

wat wil hapn if we give the both read and deny read permission to user?

2063

---

Explain comment on transactions?

936

---

Explain the microsoft sql server delete command? : SQL Server Architecture

1011

---

What is a domain constraint give an example?

1005

---

What are filegroups in sql server?

1014

---

What is the index requirement in SQL Azure?

92

---

What is the purpose of the master database?

1053

---

What is raid? : SQL Server Architecture

1106

---

What are different types of replication in sql server?

1036

---

How to optimize stored procedures in sql server?

1125

---

What is difference between stored procedure and user defined function?

1033

---

How to disconnect from a sql server using mssql_close()?

1026

---

Explain how many types of relationship?

976

---

Why use “in” clause in sql server?

997

---