Answer Posted / shyam

Union: It will combine the output of two or more queries &
it will eliminate duplicate values.

Union all:It will combine the output of two or more queries
& it will not eliminate duplicate values.

Scalability, Availability, Integration with internet, etc.)?

2884

---

What are system databases into sql server (2005/2008) : sql server database administration

1019

---

What happens to a statement batch if there is a compilation error?

969

---

Which sql server table is used to hold the stored procedure scripts?

1066

---

Where is my database stored on the hard disk in ms sql server?

1063

---

Can foreign key be duplicate?

1067

---

How to list all columns in a table using odbc_columns()?

976

---

What is a non clustered primary key?

927

---

Explain stored procedure?

1060

---

What are indexers?

1088

---

What are indexes in sql?

1285

---

Explain comment on transactions?

1005

---

How to find the service pack installed? : sql server database administration

1023

---

How do I view a stored procedure in sql server?

984

---

What is faster join or union?

1215

---