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 statistics, under what circumstances they go out of date, how do you update them? : Sql server database administration
What is table value parameters (tvp)?
Why would you call update statistics?
Explain filtered indexes?
What do I need to start working with sql studio? : sql server management studio
What are the new features in SQL Server 2005 when compared to SQL Server 2000?
What is the difference between local and global temporary tables?
Can an entity have two primary keys?
Is it safe to delete log files?
What is a self join in sql server?
How many types of attribute relationships are there? : sql server analysis services, ssas
Explain identity in sql server?
How to create median function?
Explain about Normalization?
last function used in MS Access to convert sql what function will use in sql