Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / dinesh sharma
Union:Only Select Distinct Value
Union All:Select All Values Using Duplicate
All Selected Columns Must Have Same DataType
Example:
Table 1 : First,Second,Third,Fourth,Fifth
Table 2 : First,Second,Fifth,Sixth
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What are approximate numeric data types in ms sql server?
What are the properties of sub-query?
How do you delete a data source?
What is tempdb in sql server?
How to set database to be single_user in ms sql server?
How many tables can be joined in SQL Server?
Explain full-text indexing?
What happens if null values are involved in comparison operations?
what's the difference between a primary key and a unique key? : Sql server database administration
What is tempdb database? : SQL Server Architecture
Explain transaction server isolation?
What are a database and a data warehouse?
How can you check the version of sql server?
How to view existing indexes on an given table using sys.indexes?
Explain the various types of concurrency problem. I.e. Lost or buried updates, uncommitted dependency, inconsistent analysis, phantom read?
