Interested to Buy Any Domain ? << Click Here >> for more details...
What Are Three Rules to Use UNION IN SQL SERVER
- 1 Answers
- 6474 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 |
MULTICAST DELEGATES IN C#.NET WITH REAL TIME EXAMPLE
Explain what are sparse columns?
What is primary key and example?
What is difference statement and preparedstatement?
how can do you the system monitoring?
Explain what is the purpose of sql profiler in sql server?
How many categories of functions based their return modes?
How to Update from select query in sql server?
What is the purpose of indexing?
What is the maximum length of an alert name?
Name three version of sql server 2000 and also their differences?
What is rtm version in sql server?
-
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)
