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
How to set database to be single_user in ms sql server?
Is it safe to delete log files?
Explain different types of lock modes in sql server 2000?
What are the types of lock supported by ?
How do I find the query plan in sql server?
How to replace given values with null using nullif()?
Can you type more than one query in the query editor screen at the same time?
How to create a trigger for insert only?
What are examples of triggers?
How to select true false based on column value in sql server?
What are the 2 types of classifications of constraints in the sql server?
Define synonym?
What are commonly used mssql functions in php?
What are the differences between clustered and non-clustered index?
Mention what are the different types of ssrs reports?