Answer / saravakumar

UNION RULES
A UNION must be composed of two or more SELECT statements,
each separated by the keyword UNION.
Each query in a UNION must contain the same columns,
expressions, or aggregate functions, and they must be listed
in the same order.
Column datatypes must be compatible: They need not be the
same exact same type, but they must be of a type that SQL
Server can implicitly convert.

Explain relational data?

0 Answers  

---

What is the difference between upgrade and migration in sql server?

0 Answers  

---

Why use cursor in sql server?

0 Answers  

---

How to get a list of columns using the "sys.columns" view in ms sql server?

0 Answers  

---

What are page splits? : SQL Server Architecture

0 Answers  

---

---

What is the difference between dbcc indexdefrag and dbcc reindex?

0 Answers  

---

How to remove duplicate rows from table except one?

0 Answers  

---

Why use sub query in sql server and list out types of sub queries?

0 Answers  

---

What is the difference between clustered index and primary key?

0 Answers  

---

What is the use of keyword with encryption.

0 Answers  

---

How do you identify a foreign key?

0 Answers  

---

What is the maximum number of instances in 32 bit and 64 bit sql server 2012?

0 Answers  

---