Answer Posted / 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.
| Is This Answer Correct ? | 7 Yes | 0 No |
Post New Answer View All Answers
What is exclusive locks?
What is raiseerror? What is raiseerror?
Can binary strings be converted into numeric or float data types?
How do you migrate data from mssql server to azure?
Explain comment on transactions?
What is role playing dimension with two examples? : sql server analysis services, ssas
How will you monitor replication latency in transactional replication? : sql server replication
What is the importance of concurrency control?
What is TDS(Tabular Data Stream) Gateway?
How to create a ddl trigger using "create trigger" statements?
What are the types of normalization?
What happens if null values are involved in datetime operations?
What is the difference between ddl and dml?
How to replace given values with null using nullif()?
Is sql server 2016 free?
