What Are Three Rules to Use UNION IN SQL SERVER
Answer / 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 |
What is the Control Flow in SSIS
How are SQL Server databases physically stored under Windows 2000?
how to give input dynamically to a insert statement in sqlserver
What are the different types of columns types constraints in the sql server?
What are the new features in SQL Server 2005 when compared to SQL Server 2000?
How do I create a stored procedure in dbml?
What is a view in sql?
What is join query?
How do you implement session management in SQL Server mode?
could u plz explain about joins and views?
Tell me what is sql profiler?
What is index in an assignment?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)