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
Explain Capacity planning to create a database? and how to monitor it?
How to generate random numbers with the rand() function in ms sql server?
Explain temporary table vs table variable by using cursor alternative?
Are there issues when exporting SSRS reports into Microsoft Excel? When my users are trying to export a SSRS report into Microsoft Excel, one or two columns in the report appear to merge together. Why might this be?
What is the difference between truncate and delete commands?
What are the source of constraints?
What are joins in sql and what are the different types of joins?
What are the differences between ms sql server & oracle?
What are the difference between “where” and “having” clause in sql server?
What is the difference between seek predicate and predicate?
how to restart sql server in single user mode? How to start sql server in minimal configuration mode? : Sql server database administration
what is sql server? : Sql server database administration
What are the advantages of using a stored procedure?
Do you know what is sql injection?
What is the difference between sdf and mdf?