Interested to Buy Any Domain ? << Click Here >> for more details...
What Are Three Rules to Use UNION IN SQL SERVER
- 1 Answers
- 6548 Views
- I also Faced
- E-Mail Answers
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 |
Why you need indexing? Where that is stored and what you mean by schema object? For what purpose we are using view?
How to test a dml trigger in ms sql server?
What is page in sql server?
What is simple indexing method?
What is the difference between a check constraint and a rule?
How to write a query with an inner join in ms sql server?
What is 1nf 2nf and 3nf?
How do I compare two values when one value(data type) is char and the other is an integer?
What is MSDE?
Do you know what is a trace frag? Where do we use it?
Is mysql the same as sql server?
What is the purpose of a table?
-
Oracle (3253) - 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)
