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
When columns are added to existing tables, what do they initially contain?
How to delete existing triggers using "drop trigger"?
What is the use of commit?
What is multilevel indexing?
What is database dimension? : sql server analysis services, ssas
Can you explain how long are locks retained within the repeatable_read and serializable isolation levels, during a read operation with row-level locking?
how can u get last observation in an unknown dataset ?
List some major differences between triggers and stored procedures?
Can an entity have two primary keys?
What is mscorsvw.exe - process - microsoft .net framework ngen?
Where views are stored in sql server?
Mention the different types of triggers?
Why it is recommended to avoid referencing a floating point column in the where clause?
Tell me about normalization in DBMS.
Why normalization is used?
