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 can change procedure in sql server?
What stored by the model?
What is the use of @@spid?
Describe in brief sql server monitoring ways.
Do I need a report server to run reports in my application?
What is sparse columns of sql server 2008?
Explain what are magic tables in sql server?
What is the difference between having clause and where clause in sql server?
How to delete database objects with "drop" statements in ms sql server?
What is meant by Active-Passive and Active-Active clustering setup?
Why do you need a sql server?
What is ddl and dml commands?
Do you know what are the reporting services components?
What is outer join in sql server joins?
Explain few examples of RDBMS?
