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 extended properties
How to insert and update data into a table with "insert" and "update" statements?
what is database replicaion? : Sql server database administration
What is the syntax for encrypting a column in SQL Server?
Define union, union all, minus, intersect?
Do you know what is lock escalation?
What happens when converting big values to numeric data types?
How will you hide an attribute? : sql server analysis services, ssas
What is normalization 1nf 2nf 3nf?
can an automatic recovery be initiated by a user? : Sql server administration
Can we write ddl in trigger?
If I delete a template from the list in sql studio, will it be deleted from the hard disk? : sql server management studio
What does it mean to normalize data?
What is index, cluster index and nonclustered index?
Tell me what is the stuff and how does it differ from the replace function?